This can only be achieved by utilizing some sort of type system. Whether it's reflecting on the tables, codegen on the fly, or having to write custom adapters for each structure. All of which can be greatly simplified with an ORM.
It's not going to help much with bespoke report asks from the business though.
The sane middle ground is libraries that give you nicer ergonomics around SQL without hiding it (like Golangs sqlx https://github.com/jmoiron/sqlx). Engineers should be writing SQL, period.
The blog suggests that an ORM for OLAP would do exactly that
This really highlights the place for _both_ OLTP and OLAP DBs.
OLTP: when you need to select one
OLAP: when you need to select the world
To me, this sounds... naïve at best. Coal and especially oil are well-moneyed interests, and also important voting groups.
It's also an ideological, but not entirely nonsensical, fight against subsidizing industries. Which is not quite wise, at the time when China still seriously subsidizes solar and wind.