Show HN: RooQL – A semantic layer with no server (Ossie models to SQL)

Category: devtools

Tags: semantic-layer, sql, compiler, analytics, apache-ossie

Score: 7.0/10 (Innovation: 7, Technical: 7, Documentation: 8, Utility: 6)

RooQL is a client-side semantic layer that compiles metric queries into SQL from an Apache Ossie semantic model, running entirely in the app (browser or Node) with no server. It supports multiple SQL dialects (Snowflake, DuckDB, BigQuery) and refuses queries it cannot answer correctly, preventing silent wrong results. The project is interesting for its lightweight, embeddable approach to semantic modeling and its focus on correctness via typed errors.

Target audience: data engineers, backend developers, analytics engineers

Repository: https://rooql.com/play/ · JavaScript · Apache-2.0 · 3 stars

View on Hacker News