GitHub Repository

A lightweight, injection-proof query language for building type-safe SQL filters across Go, Python, and JavaScript.

9 starsJavaScript

FlyQL: query language to filter data or generate SQL

Name: FlyQL: query language to filter data or generate SQL
Availability: InStock
Author: r0b3r4

by r0b3r4·May 15, 2026·3 points·0 comments

Visit Project View on HN

AI Analysis

●●SolidBig BrainNiche Gem

Injection-proof filter language with cross-language parity in Go, Python, and JS.

Strengths

•Parses natural language filters into a portable AST preventing SQL injection risks.
•Maintains strict implementation parity across three major backend languages.
•Includes a ready-to-use Vue 3 editor component for immediate UI integration.

Weaknesses

•Limited to three specific SQL dialects excluding MySQL and SQL Server support.
•Vue 3 component excludes React or Svelte users without custom wrappers.

Post Description

Hey HN.

I want to share small library which i made.

While I developing my log viewer (https://github.com/iamtelescope/telescope) I needed a way for users to filter the data in my UI. Something like `status = 500 and level = "error"`. And on the backend i need to convert it into the SQL. And by default I don't want to give users raw SQL (because of security concerns).

So I create simple parser for this.

Later, I have another project and I needed exactly same thing, but for PostgreSQL. And later for my CLI stuff. So i decided to extract this telescope thing in a standalone library/project and call it FlyQL.

FlyQL is tiny filter language. It has implementation in three languages for today: Python, Golang and JavaScript. And it has support for 3 SQL dialects: ClickHouse, StarRocks and PostgreSQL.

Also, there are Vue3 editor component, which allows to easily use it in your own UI (if you are using vue)

Would love to hear any feedback.

MIT Licensed.

GitHub: https://github.com/iamtelescope/flyql

Playground: https://flyql.dev/playground/

Documentation: https://docs.flyql.dev/