Stefan de Konink Yes, in https://tobilg.com/handling-gtfs-data-with-duckdb#heading-loading-the-dataset-in-a-new-gtfs-database I mention that users will have to write their custom loading scripts taking thing like wrong column order into account.

Thanks for the feedback! Not sure if I understood correctly, as I'm "fixing" the problems you describe with custom loading scripts by provider, e.g. https://github.com/tobilg/duckdb-gtfs/blob/main/queries/providers/gtfs-de/full/load_data.sql This works w/o problems for me so far. What do you mean by "huge non-CSV files" Stefan de Konink ? The GTFS standard specifies CSV as format, so I'm a bit confused.

Sure, please do! Glad you like it!

Yes, you can attach to a remote database, see https://tobilg.com/using-duckdb-wasm-for-in-browser-data-engineering#heading-attaching-remote-databases

Thanks! It's a React application just running in the frontend.

The SQL Workbench is based on DuckDB WASM, as stated in the article, and works entirely in your browser. No data is sent to other servers etc. Regarding running it locally, it's currently not Open Source, so there's no way to do this right now.

Thank you for the nice feedback!

This is replaced by the Serverless Framework during deployment. See https://www.serverless.com/framework/docs/providers/aws/guide/variables#reference-variables-in-javascript-files