Malloy is a newish data language with semantic models... Perhaps what semantic SQL would look like: https://www.malloydata.dev/