DelightQL
A functional query language that compiles to SQL
Developer ToolsFree#sql#compiler#cli
Listed by the ProductPerch team from lobste.rs · not launched here yet
What is DelightQL?
DelightQL is a data query language designed to transpile into standard SQL. Its syntax combines elements of logic and functional programming to make database queries more concise and reusable.
The tool provides familiar programming constructs like local functions, composition, and piping while keeping the relational capabilities of SQL. It handles common operations such as column projection, tree building, joins, pivoting, and window functions.
Built in Rust with a command line interface, DelightQL currently targets SQLite and DuckDB. The project is in alpha and relies on tree-sitter for parsing. Source code is hosted on GitHub.
DelightQL features
- Transpiles queries to standard SQL dialects
- Functional syntax with piping and composition
- Local functions and expression naming
- Tree building and nested collection handling
- Column projection and pattern matching
- Pivot, melt, and ragged union operations
- Window functions and filtered aggregates
- Command line interface for UNIX systems
Who uses DelightQL and for what
- Writing complex SQL queries using a cleaner functional syntax
- Building reusable query templates for team databases
- Transforming and reshaping tabular data before storage
- Creating nested JSON-like structures from relational tables
- Applying consistent transformations across multiple datasets
DelightQL FAQ
Is DelightQL free?
Yes, DelightQL is free to use and its source code is publicly available on GitHub.
Is DelightQL open source?
Yes, the project repository is hosted on GitHub under an open license.
What is DelightQL used for?
It is used to write data queries that compile into SQL, offering functional programming features alongside traditional relational operations.
Does DelightQL work on Mac?
The website states it provides a CLI for major UNIX flavors, which includes macOS.
What SQL databases does DelightQL support?
It currently supports SQLite well and offers partial support for DuckDB. Other dialects are planned for future releases.
Comments (0)
Comments and upvotes open when this product launches on ProductPerch.
More Developer Tools launches
Monitor Laravel scheduled tasks and queues
Feel iOS haptic patterns on a real iPhone, copy the code
Deploy anywhere from your AI tool.
Python code quality analyzer for developers
Free product launch platform for indie makers
eBay listing data for apps and agents
