Trilogy: Composable, reusable analytics — a SQL-based language that’s type-safe, testable and fun to use. Model once. Run anywhere.
Familiar
Looks like SQL. Feels like code.
Accurate
No gotchas with grouping or joins.
Testable
Type-safe analytics with modular, testable logic.
Efficient
Write less. Stage less. Run what matters.
Extendable
Open source. Rich python API.
Composable
Models as building blocks: share, reuse, and compose with ease.
Perfect for AI
Exactly the context LLMs need, but human readable/writable.
Install
pip install pytrilogy
Trilogy is a data modeling language with first-class support for logic, functions, and reuse. Here's a hello world: