Get the latest tech news
Show HN: Trilogy – A Reusable, Composable SQL Experiment
Typed, declarative ETL and query language that compiles to SQL.
No benchmarking right now, though - we just care that DuckDB can natively produce a nice representative data warehouse for TPC-DS with a built in extension, and that this dataset gives us a good way to explore the language syntax. The ~ symbol in this example is an optional modifier to indicate that the values being merged in might not be complete - eg not every date might be in store_sales.date - and so querying for the root concept should left outer join across to the other models.. Trilogy-NLP can either be used in an interactive analytics context, as a helper for users to write queries, or as a backend for a chatbot or other natural language interface to a database.
Or read this on Hacker News
