Hello Calcite Team, Hope this email finds you well.
I have a use-case which we want to tackle where we want to query with multiple databases using one SQL query. I have data in 2 different relational databases with multiple tables within them. I want to query the data within them using just one SQL query referencing tables from both databases. The query should support following operations on the data within the tables in the relational databases: JOINs, GROUP BY HAVING, AGGREGATION functions, PROJECTIONS, WINDOW Functions, etc. Will Caclite help in solving such Query (or Data) Federation use-cases? If yes, is there any kind of documentation, videos or articles that will be useful in solving this problem? Your help is much appreciated. Thanks & Regards, Aditya M.