Preql/Trilogy is a declarative and typed query and ETL language that compiles to SQL. Typescript for SQL, with a built in semantic layer.

Try It → Why Preql?


PreQL/Trilogy syntax enhances standard SQL, making it accessible to users and developers alike. For most users, it's just SQL, but easier to write.


The compiler streamlines complex aggregations and enforces type checking and other correctness guarantees at compile time, ensuring your results can be trusted.


The PreQL/Trilogy data model ensures your dashboards and queries are accurate, efficient, and testable as your data grows, minimizing sprawling intermediate tables and views.