So, it should be pretty straightforward to let folks drop a SQLite file instead of a CSV file! I haven't been able to get extensions to work on WASM so far though but I will definitely take a look to see if we can make this work!
However, using Sqlite requires a duckdb extension and i'm not sure if works for wasm, and if so enabled this project in particular.
https://duckdb.org/docs/guides/import/query_sqlite
But I believe that most of these duckdb web-IDEs will revolve around a couple of generalized used cases:
1. OLAP/analytical type workloads/queries. Sqlite is really more for OLTP/transactional workloads.
2. Querying datasets that are available on, targeted for blob/object storage like S3. Parquet, CSV, line-delimited JSON, etc