dialect

type ColumnMeta struct {
	Name       string
	SQLType    string
	Nullable   bool
	PrimaryKey bool
}

type ColumnSpec struct {
	PrimaryKey    bool
	AutoIncrement bool
	NotNull       bool
	Unique        bool
	HasDefault    bool
	Default       string
	SQLType       string
}

type DDL interface {
	ColumnDefinition(goType reflect.Type, spec ColumnSpec) (string, error)
	InlinesPrimaryKey(spec ColumnSpec) bool
	AlterColumnSQL(table, column string, goType reflect.Type, spec ColumnSpec) (string, error)
	DropIndexSQL(table, index string) string
	RenameIndexSQL(table, oldName, newName string) (string, error)
	HasTableSQL(table string) (string, []any)
	HasColumnSQL(table, column string) (string, []any)
	HasIndexSQL(table, name string) (string, []any)
	HasConstraintSQL(table, name string) (string, []any)
	GetTablesSQL() (string, []any)
	ColumnTypesSQL(table string) (string, []any)
	CurrentDatabaseSQL() string
}

type Dialect interface {
	Name() string

	QuoteIdent(name string) string

	Placeholder(n int) string

	SupportsILike() bool

	SupportsRowLocking() bool

	SupportsReturning() bool

	SupportsOnConflict() bool

	SupportsSavepoints() bool
}