TL;DR
· ORMs have proven to be useful for many developers in the OLTP/transactional stack (Postgres, MySQL, etc).
· OLAP/analytical databases like ClickHouse could potentially benefit from ORM abstractions.
· Existing transactional ORMs probably shouldn’t be extended to OLAP due to fundamental differences in semantic meaning between OLTP and OLAP.
· Moose OLAP (part of MooseStack) is an open source, MIT-licensed implementation of an ORM-like interface for ClickHouse, inspired by transactional ORMs, but adjusted for the OLAP world.
... continue reading