Sql
- How I format lines into commas, quotes, and SQL lists
A lot of cleanup work starts as one item per line and needs to become a comma-separated list, quoted list, JSON-ish array, or SQL IN clause. The Line Comma Formatter tool handles the repetitive part so I can focus on …
- How I format SQL before reviewing a query
SQL is easier to review when clauses and joins are on separate lines instead of one long string. The SQL Prettify tool helps me inspect the input and output without writing a one-off script first.
- How I generate SQL INSERT statements from CSV or JSON
Sometimes I have a small table of data and need to insert it into a database. For a few rows, writing SQL by hand is fine. For many rows, it is boring and error-prone.