Trilogy is better analytic SQL; composable, reusable, and delightful. Model once. Run anywhere.
Familiar
Trilogy looks like SQL, just simpler.
Accurate
Eliminate common pitfalls around grouping and joins.
Testable
Separate business logic from data. Types enforced at compile time.
Efficient
Minimize temp and staging tables. Run just what you need.
Extendable
Open source. Rich python API.
Composable
Simple sharing, reuse, functions, and composability.
LLM-Native
Simpler than SQL for humans and AI.
Install
pip install pytrilogyHello, World
#-- define your model
const greeting <- 'hello';
key object string;
#-- bind it to data
datasource objects (
object:object
)
grain (object)
query '''
select unnest(['world', 'friend', 'visitor']) as object
''';
def initcap(word)-> upper(substring(word, 1, 1)) || substring(word,2, len(word));
#-- and run your SQL
WHERE object like '%world%' or object = 'friend'
SELECT
greeting || ' ' || @initcap(object) || '!' as salutation,
rank salutation by len(salutation) asc as brevity_rank
;