Preql/Trilogy is a declarative and typed query and ETL language that compiles to SQL. Typescript for SQL, with a built in semantic layer.
Familiar
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.
Accurate
The compiler streamlines complex aggregations and enforces type checking and other correctness guarantees at compile time, ensuring your results can be trusted.
Efficient
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.