dialect

type ColumnValue struct {
	Column string
	Value  any
}

type Dialect interface {
	SupportsReturning() bool
	// Now returns the SQL expression for the current timestamp.
	// Postgres returns "NOW()", SQLite returns "CURRENT_TIMESTAMP".
	Now() string
	// Explain returns a query that produces a textual execution plan for the
	// given query, and whether the dialect supports plan inspection in the form
	// drel uses for missing-index hints. SQLite returns ("", false).
	Explain(query string) (string, bool)
	BuildSelect(node ast.SelectNode) Result
	BuildInsert(table string, columns []string, values []any, returningCols []string) Result
	BuildUpdate(table string, changes []ColumnValue, pkColumn string, pkValue any) Result
	BuildDelete(table string, pkColumn string, pkValue any) Result
	BuildSoftDelete(table string, pkColumn string, pkValue any) Result
	BuildUpdateVersioned(table string, changes []ColumnValue, pkColumn string, pkValue any, versionCol string, currentVersion int) Result
	BuildBulkInsert(table string, columns []string, rows [][]any) Result
	BuildBulkUpdate(table string, sets []ColumnValue, where *ast.WhereClause) Result
	BuildBulkDelete(table string, where *ast.WhereClause) Result
	BuildBulkSoftDelete(table string, where *ast.WhereClause) Result
	BuildBulkUpsert(table string, columns []string, rows [][]any, conflictCols []string, updateCols []string) Result
}

type RawExpr struct {
	SQL string
}

type Result struct {
	SQL  string
	Args []any
}