Not a SQL replacement, but if you're looking for an open source semantic layer, Cube is the way to go [0]

0 - https://github.com/cube-js/cube