Since someone has already mentioned Apache Calcite once... Take a look at https://calcite.apache.org/avatica/ https://calcite.apache.org/avatica/ -- it does so

Since someone has already mentioned Apache Calcite once... Take a look at https://calcite.apache.org/avatica/ https://calcite.apache.org/avatica/ -- it does some of what you're mentioning.