I'm investigating if calcite can help my company provide an SQL interface to it's proprietary data engine.
While reading through the docs <https://calcite.apache.org/docs/tutorial.html>, in the *Current limitations* section, it says that Calcite doesn't support pushing down filtering, joins, aggregations but can push down table scans only. While in that in this page <https://calcite.apache.org/docs/>, it says "Calcite uses optimizer rules to push the JOIN and GROUP BY operations to the source database", so I guess the limitation paragraph is outdated ? The page also says that "Calcite intentionally stays out of the business of storing and processing data." but I understand that Calcite implements some SQL operators, doesn't this mean that Calcite processes data ? For the driver question, I went through the test cases for the CSV adapter and I found some tests getting a connection using: Connection connection = DriverManager.getConnection("jdbc:csv:", info); But I couldn't figure out how could the CSV adapter register a driver by that URL (i.e. jdbc:csv) and where in the test cases is this driver registered ? Thanks, Gelbana
