builder

type CTEDef struct {
	Name      string   // CTE name (will be validated/quoted)
	Columns   []string // optional column list
	SelectSQL string   // the SELECT query (should be built safely)
}

type ConditionGroup struct {
	Conditions []string
	Args       utils.JSON
	// contains filtered or unexported fields
}

type DeleteQueryBuilder struct {
	SourceName string              // Table name for DELETE FROM
	DbType     base.DXDatabaseType // Database type for syntax differences
	Error      error               // Accumulated error
	Conditions []string            // WHERE conditions
	Args       utils.JSON          // WHERE clause arguments
	OutFields  []string            // RETURNING/OUTPUT fields
}

type HavingConditionDef struct {
	Expression string         // aggregate expression (e.g., "COUNT(*)", "SUM(amount)")
	Operator   HavingOperator // =, >, <, >=, <=, <>
	Value      any            // parameterized value
	ParamName  string         // parameter name for binding
}

type HavingOperator string

type InsertQueryBuilder struct {
	SourceName string              // Table name for INSERT INTO
	DbType     base.DXDatabaseType // Database type for syntax differences
	Error      error               // Accumulated error
	SetFields  utils.JSON          // Fields to insert (column -> value)
	OutFields  []string            // RETURNING/OUTPUT fields
}

type JoinDef struct {
	Type    JoinType // INNER, LEFT, RIGHT, FULL
	Table   string   // table/view name (will be quoted)
	Alias   string   // optional alias
	OnLeft  string   // left field of ON condition (can include table prefix)
	OnRight string   // right field of ON condition (can include table prefix)
}

type JoinType string

type OrderByDef struct {
	FieldName     string // field name (will be validated and quoted)
	Direction     string // "asc" or "desc" (use databases.DXOrderByDirection* constants)
	NullPlacement string // "first" or "last" (use databases.DXOrderByNullPlacement* constants), empty for default
}

type SelectQueryBuilder struct {
	// Source name for FROM clause (table or view name)
	SourceName string

	// WHERE clause building
	Conditions []string
	Args       utils.JSON
	DbType     base.DXDatabaseType
	Error      error

	// Extended SQL clause building
	Joins            []JoinDef
	CTEs             []CTEDef
	GroupByFields    []string
	HavingConditions []HavingConditionDef
	OrderByDefs      []OrderByDef
	RawOrderBys      []string // Raw ORDER BY expressions (e.g., PostGIS distance)
	OutFields        []string // OutFields for SELECT or RETURNING clause
	LimitValue       int64    // LIMIT clause value (0 = no limit)
	OffsetValue      int64    // OFFSET clause value (0 = no offset)
	ForUpdatePart    any      // FOR UPDATE clause (string like "FOR UPDATE", or bool true)
	// contains filtered or unexported fields
}

type UpdateQueryBuilder struct {
	SourceName string              // Table name for UPDATE
	DbType     base.DXDatabaseType // Database type for syntax differences
	Error      error               // Accumulated error
	SetFields  utils.JSON          // Fields to update (column -> value)
	Conditions []string            // WHERE conditions
	Args       utils.JSON          // WHERE clause arguments
	OutFields  []string            // RETURNING/OUTPUT fields
}