It looks like Apache Doris supports the MySQL wire protocol, so you should be able to connect by adding a MySQL data source in GrowthBook.
I'm not too familiar with Apache Doris, so not 100% sure it supports all of the joins and CTEs that we use in our queries. We don't do anything too crazy, but I know some tools like Apache Druid have really limited JOIN support.