OLTP vs OLAP

OLTP vs OLAP use cases

How Ebean fits in OLTP vs OLAP use cases, when to use manually supplied SQL

Ebean ORM queries are good for typical OLTP query use cases but there are many queries that can be written in SQL that ORM is not well suited to in the reporting and OLAP area.

Ebean ORM queries are focused to OLTP. Don't forget about using SQL where appropriate.

For Ebean the focus is to use ORM queries for OLTP use cases. The plan is not to expand the ORM query language to cover OLAP queries but to instead have good integration with SQL via findNative, RawSql and SqlQuery.