What’s the Best Way to Share SQL and Python Query Results with External Users?

It really depends on your audience. For Big Data projects, I'm converting tables to parquet files and letting researchers load those into Python for their analyses.

As an alternative to Power BI, you could explore the Evidence framework. It allows you to write SQL queries against DuckDB and pre-loads them for quick reuse. You can build dashboards using a Markdown/HTML syntax, which is great for version control with git. In the end, it creates a static HTML dashboard which could work well for your needs!

If you're looking to allow users to view datasets based on specific parameters and create their own dashboards or visualizations, you might want to try Metabase. It offers data sandboxing, and you wouldn't have to build everything from scratch. However, if you're up for some DIY, libraries like Flask or FastAPI could also work for exporting datasets, especially if you include an authentication layer to manage user access.

Have you considered using Grafana? It’s a solid tool for visualizing data and letting users interact with your datasets.

I built a backend API that fetches data from SQL or files and sends it to the frontend. To let users filter and perform complex SQL queries like joins, I'm using DuckDB with WebAssembly and some JavaScript. It allows the client to have its own SQL engine, so I don’t stress about sandboxing queries on the backend. It’s been a game-changer for me!

Have you thought about using Power Query in Excel or Power BI? It’s designed for this kind of task where you want to save embedded data and allow users to interact with it.