postgresql

package

v0.53.0 Latest Latest Go to latest Published: May 1, 2026 License: Apache-2.0 Imports: 2 Imported by: 0

Details

Build-tagged PostgreSQL parser adapter for parser wiring and parser-neutral extractor handoff.

File	Responsibility
parser.go	Parses PostgreSQL SQL text and classifies statements when built with the `postgresql` tag
extractor.go	Defines the PostgreSQL extracted-statement wrapper and extractor that populates normalized spec fields (column `NotNull`, `Default`, constraints) for ALTER TABLE ADD COLUMN statements
parser_stub.go	Returns the PG-capable build guidance error when PostgreSQL support is not compiled in

The extractor populates CONSTR_NOTNULL and CONSTR_DEFAULT constraints on ALTER TABLE ADD COLUMN into the normalized spec column fields, enabling rules that depend on these facts.
The extractor normalizes advanced PostgreSQL CREATE INDEX forms (partial, expression, INCLUDE, non-btree access methods) into coarse spec.Index facts. DeltaScope does not render or semantically analyze predicate SQL or expression SQL.
The extractor normalizes ALTER TABLE SET SCHEMA (dispatched via AlterObjectSchemaStmt), OWNER TO, named trigger enable/disable, and partition attach/detach into spec.Alter actions. These 6 normalized actions are covered by dedicated PG-only advisory/warning/notice rules. Trigger ALL/USER variants and partition bound semantics are not interpreted.
The extractor normalizes schema, sequence, and materialized view create/drop lifecycle forms into spec.DDL with ObjectName / ObjectType. Sequence numeric values and materialized view query semantics are not interpreted. REFRESH MATERIALIZED VIEW is normalized with concurrently and with_no_data coarse facts. DeltaScope does not verify unique-index requirements for concurrent refresh or analyze materialized view query SQL.
This adapter only establishes the parser seam and normalized statement extraction.
Rich PostgreSQL statement extraction continues to expand across phases.

This section is empty.

This section is empty.

This section is empty.

type ExtractedStatement struct {
	Kind      spec.Kind
	RawSQL    string
	Extractor spec.StatementExtractor
}

type Parser struct{}

func New() *Parser

func (p *Parser) Parse(_ string) (Result, error)

type Result struct {
	Statements []ExtractedStatement
	Warnings   []string
}