Unrelated but I once stumbled with http://cubes.databrewery.org/index.html
While the domain modeling exerts (some/lots of) friction, an OLAP ORM adaptation may result from forking their concept.
Does OLAP Need an ORM
51–52 of 52 posts
Re: Does OLAP Need an ORM
#52If you're doing OLAP, you probably want dimensions, measures and operators that operate on time aggregations and shifts. You want rollups and drill downs along multiple axes, with subtotals and probably pivots. SQL isn't wholly adequate for this, it's hard work to get the SQL right and if there's joins involved it's not hard to accidentally fan out and start double counting. If you ask me, you want an analytic model…
I fully agree. This is why I created a SQL query engine for my own need few years ago, it is not open-sourced. It is called SquashQL (https://github.com/squashql/squashql). It provides a "simple" API (available in Typescript and Java for now) to perform "complex" and "dynamic" SQL queries such as pivot queries, standard queries with rollups or partial rollups with the ability to hide totals and subtotals, time-series and hierarchical comparison, bucketing, drilling across and more...