Metabase dev here.

Metabase is a general purpose BI tool that anyone in your company can use (whether they know SQL or not) to ask questions about your data, make charts and dashboards, etc.

It sounds like Squealy is primarily focused on generating APIs from SQL for integration in another applications.

That isn't Metabase's primary focus right now, but we do have the ability to embed charts or dashboards in other applications, as well as JSON and CSV APIs for each question (though that's not well documented).

Each question or dashboard can be parameterized, for example by a customer ID, and authenticated via JWT.

This works for questions built using our UI as well as SQL. We don't have a full template system in SQL yet, but we do let you add parameters to your SQL.

If you feel like we're missing a feature that would be useful, please file an issue! https://github.com/metabase/metabase/issues

This was my question as well. Metabase is continuously getting better - why would one divest themselves from metabase for this? What are the primary advantages?

- 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

Squealy focuses more on APIs rather than giving out-of-the box visualizations. With custom APIs, you can easily embed the reports within your own dashboard that can be shared with all your customers.

Also squealy lets you write Jinja templated SQL queries that's helpful in extracting some complex insights from the data.