> can solve it with a low level common IR Wouldn't that basically just be a query plan? The language is the easy part. Determining the optimal query plan base

> can solve it with a low level common IR Wouldn't that basically just be a query plan? The language is the easy part. Determining the optimal query plan based on rough statistics about the data and the DBs ability to go about that is the hard part. There are more general purpose query optimization libs out there, like Calcite