Show HN: FlyQL: query language to filter data or generate SQL

r0b3r41 pts0 comments

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/

show flyql query language filter data

Related Articles