Apache Calcite
SQL planning and optimization
What it does
Calcite provides SQL parsing, query optimization, and an adapter framework that data systems can use to build their own query layer.
When to use it
When building access to a new source, use its adapter tutorial to understand mappings between relational operations and external data structures.