Skip to content

feat(expander): Add star expander for SELECT * and RETURNING * (PostgreSQL, MySQL, SQLite) #4203

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
kyleconroy merged 8 commits into from
Dec 1, 2025
Merged

feat(expander): Add star expander for SELECT * and RETURNING * (PostgreSQL, MySQL, SQLite) #4203

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
8 commits
Select commit Hold shift + click to select a range
5f89eb2
feat(postgresql): Add star expander for SELECT * and RETURNING *
kyleconroy Nov 30, 2025
475cfcf
feat(expander): port expander to use internal AST types
kyleconroy Dec 1, 2025
3b8932c
feat(expander): add MySQL support and use ColumnGetter interface
kyleconroy Dec 1, 2025
dd128fe
fix(expander): use valid MySQL syntax for edge case tests
kyleconroy Dec 1, 2025
e7836b8
feat(expander): add SQLite support
kyleconroy Dec 1, 2025
3c31da6
refactor(expander): use PrepareContext in SQLColumnGetter
kyleconroy Dec 1, 2025
ffc490b
refactor(expander): use native ncruces/go-sqlite3 API for column names
kyleconroy Dec 1, 2025
f1bbc6e
refactor(expander): use forked MySQL driver and fix list formatting
kyleconroy Dec 1, 2025
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Next Next commit
feat(postgresql): Add star expander for SELECT * and RETURNING * 
Adds a new expander package that expands * expressions in SQL queries
to explicit column names by preparing the query against a PostgreSQL
database.

Features:
- Expands SELECT * to explicit column list
- Preserves table prefix for qualified stars (e.g., table.*)
- Handles RETURNING * in INSERT/UPDATE/DELETE statements
- Recursively expands CTEs, including dependent CTEs
- Supports subqueries in FROM clause
- Works with both cgo (pganalyze/pg_query_go) and non-cgo
  (wasilibs/go-pgquery) builds

Example:
  SELECT * FROM authors
  → SELECT id, name, bio FROM authors

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <[email protected]>
  • Loading branch information
@kyleconroy @claude
kyleconroy and claude committed Dec 1, 2025
commit 5f89eb297d442509e2294872d8d7c4bb62b06317
Loading