[Question] Can I make custom connector to query multiple databases via single query

[xsgao-github]

About You:
Name: Song Gao
Company: Starburst Data Inc.

Can I make a custom connector to query multiple databases via a single query?

To get data from various databases (within the same server), I must create multiple connections and blend the data within Tableau.

However, this will generate multiple queries to my data source and multiple intermediate results will be blended within Tableau. Because my data source supports query federation, I would like to force my custom connector to send one single query that joins data from various databases. Is that possible?