Hacker News new | ask | show | jobs
by ashtavakra 3329 days ago
Interesting. If someone here have used https://openbouquet.io/ before - how is SQeaLy different for Boquet?
1 comments

I have not used Boquet but going through their documentation it looks like they help developers to get rid of SQL by providing some Javascript plugin in order to filter the reporting data from the database.

SQueaLy's approach is a bit different. It is rather focused on writing powerful and dynamic SQL queries. SQueaLy uses JinjaSQL behind the scenes which gives you the power to use JINJA inside the SQL query. For more details, check out JinjaSQL here - https://github.com/hashedin/jinjasql

With JinjaSQL in the scene, you can access real-time variables related to

- A logged-in user

- Web session

- URL query parameters

inside your SQL queries.

You can then use Jinja templating inside the SQL query to handle conditional statements or create macros based on these real time variables