For those who don’t know, that’s called a semantic layer in business intelligence https://www.datacadamia.com/data/type/cube/semantic/semantic

It’s a sql that compiles to the real database sql based on configuration.