swapnil95

Yes SQueaLy does support Athena. As of now we support Athena, Redshift, Mysql, Postgres and sqlite

Soon we will be adding support for Mssql and Cassandra also

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

- Fine-grained authorized REST APIs

- Cron based scheduled emails embedded with reports

- Auto-generated documentation for all the REST APIs using swagger

- More than just SQL - SQueaLy uses JinjaSQL behind the scenes which gives you power to use JINJA inside the SQL query.

You can refer the readme for more details

Yes you got it right. The focus of SQueaLy is on providing fine grained authorized REST APIs with auto generated documentation for all the REST APIs using swagger.

Hey, I have replied to your issue on github

On the web frontend, we paginate the reports and so it is supposed to be responsive with large datasets. We tested this with around 10K rows, we'll surely scale-up our tests for this.

BTW which charting library are you using for your reports?

Thanks Josh. Hope to get more feedbacks from you.