builder

type BuildOptions struct {
	FormatStyle      FormatStyle `json:"format_style"`
	IndentSize       int         `json:"indent_size"`
	MaxLineLength    int         `json:"max_line_length"`
	UseDoubleQuotes  bool        `json:"use_double_quotes"`
	NormalizeNames   bool        `json:"normalize_names"`
	PreserveComments bool        `json:"preserve_comments"`
	PostgreSQLMode   bool        `json:"postgresql_mode"`
}

type ColumnDefinition struct {
	Name                string `json:"name"`
	DataType            string `json:"data_type"`
	NotNull             bool   `json:"not_null"`
	Default             string `json:"default,omitempty"`
	Generated           bool   `json:"generated"`
	GeneratedExpression string `json:"generated_expression,omitempty"`
	GeneratedStored     bool   `json:"generated_stored"`
	Collation           string `json:"collation,omitempty"`
	Comment             string `json:"comment,omitempty"`
}

type ConstraintDefinition struct {
	Name              string   `json:"name,omitempty"`
	Type              string   `json:"type"`
	Columns           []string `json:"columns"`
	RefTable          string   `json:"ref_table,omitempty"`
	RefColumns        []string `json:"ref_columns,omitempty"`
	OnDelete          string   `json:"on_delete,omitempty"`
	OnUpdate          string   `json:"on_update,omitempty"`
	CheckExpression   string   `json:"check_expression,omitempty"`
	Deferrable        bool     `json:"deferrable"`
	InitiallyDeferred bool     `json:"initially_deferred"`
}

type FormatStyle int

type FunctionDefinition struct {
	Schema     string                 `json:"schema"`
	Name       string                 `json:"name"`
	Parameters []*ParameterDefinition `json:"parameters"`
	ReturnType string                 `json:"return_type"`
	Language   string                 `json:"language"`
	Body       string                 `json:"body"`
	Volatility string                 `json:"volatility"` // VOLATILE, STABLE, IMMUTABLE
	Strict     bool                   `json:"strict"`
	Security   string                 `json:"security"` // DEFINER, INVOKER
	Comment    string                 `json:"comment,omitempty"`
}

type IndexColumn struct {
	Name       string `json:"name,omitempty"`
	Expression string `json:"expression,omitempty"`
	Order      string `json:"order,omitempty"` // ASC, DESC
}

type IndexDefinition struct {
	Schema                  string         `json:"schema"`
	Table                   string         `json:"table"`
	Name                    string         `json:"name,omitempty"`
	IfNotExists             bool           `json:"if_not_exists"`
	Unique                  bool           `json:"unique"`
	Method                  string         `json:"method"`                     // BTREE, HASH, GIN, GIST, etc.
	HadExplicitAccessMethod bool           `json:"had_explicit_access_method"` // BUG-001: Track if USING was explicit
	Columns                 []*IndexColumn `json:"columns"`
	Where                   string         `json:"where,omitempty"`
	Comment                 string         `json:"comment,omitempty"`
}

type ParameterDefinition struct {
	Name    string `json:"name,omitempty"`
	Type    string `json:"type"`
	Mode    string `json:"mode,omitempty"` // IN, OUT, INOUT
	Default string `json:"default,omitempty"`
}

type SQLBuilder struct {
	// contains filtered or unexported fields
}

type TableDefinition struct {
	Schema      string                  `json:"schema"`
	Name        string                  `json:"name"`
	IfNotExists bool                    `json:"if_not_exists"`
	Columns     []*ColumnDefinition     `json:"columns"`
	Constraints []*ConstraintDefinition `json:"constraints"`
	Inherits    []string                `json:"inherits,omitempty"`
	Tablespace  string                  `json:"tablespace,omitempty"`
	Comment     string                  `json:"comment,omitempty"`
}