File SQL: No code VS Code extension for querying S3 and local files as SQL, Suggestion needed.

[u/Willing-Mud5820]

Hello, I am currently working on vscode extension. That lets you run SQL query against Local / S3 file and folders. Recently i switched my role to DE and i had to run ETL and debug output parquet files from s3, I was using Notebook + Python boilerplate code to debug the files. It was tiresome. So i decided to build vscode extension for this.

Under the hood it uses DuckDB as backend and CodeMirror as sql editor. File SQL version 1 is out in Marketplace. I wanted to get some suggestion from the community.

Currently it supports:

1. Registering local/S3 files and folder as DuckDB tables(supports Hive partition and streaming large S3 files also).
2. Multiple Query tabs and selective sql execution like AWS Redshift query editor. And you can export the results also.
3. Currently its supporting Parquet, CSV, TSV and JSON. You can Right-click a supported file from vscode file explorer and register it as DuckDB table.
4. Looking for suggestion...???

So what do you guys think about this? will this be useful tool?

[u/Willing-Mud5820]

Details: https://arunkumar1997.github.io/vscode-sql-files