The key insight is that rsql_executor.py mirrors the production execute_sql_scripts.py flow, but replaces the rsql CLI (which requires a Redshift cluster) with psycopg2 (which connects to a local ...
├── backend/ │ ├── .env # Environment variables (API keys, DB credentials) │ ├── .env.example # Example env file for reference │ ├── database-setup.sql # SQL script to set up database schema │ ├── ...