dialect

type Dialect interface {
	// Name returns the dialect name (e.g., "postgresql", "mysql").
	Name() string

	// CreateTableSQL generates a CREATE TABLE statement.
	CreateTableSQL(table *types.Table) string

	// CreateTableIfNotExistsSQL generates a CREATE TABLE IF NOT EXISTS statement.
	CreateTableIfNotExistsSQL(table *types.Table) string

	// DropTableSQL generates a DROP TABLE statement.
	DropTableSQL(schema, name string) string

	// DropTableIfExistsSQL generates a DROP TABLE IF EXISTS statement.
	DropTableIfExistsSQL(schema, name string) string

	// AlterTableSQL generates ALTER TABLE statements for all actions.
	AlterTableSQL(schema, tableName string, actions []*types.TableAction) []string

	// HasTableSQL returns SQL to check if a table exists (returns count).
	HasTableSQL(schema, tableName string) string

	// HasColumnSQL returns SQL to check if a column exists (returns count).
	HasColumnSQL(schema, tableName, columnName string) string

	// ColumnDefinitionSQL generates the column definition for use in CREATE TABLE.
	ColumnDefinitionSQL(col *types.Column) string

	// CommentColumnSQL returns SQL to add a comment to a column.
	CommentColumnSQL(tableName, columnName, comment string) string

	// QuoteIdentifier quotes an identifier (table/column name) for this dialect.
	QuoteIdentifier(name string) string

	// QualifyTable returns a schema-qualified table name.
	// If schema is empty, returns just the quoted table name.
	QualifyTable(schema, tableName string) string

	// CreateMigrationsTableSQL returns SQL to create the migrations tracking table.
	CreateMigrationsTableSQL(tableName string) string

	// InsertMigrationSQL returns parameterized SQL to record a migration.
	// Parameters: $1=name, $2=batch
	InsertMigrationSQL(tableName string) string

	// DeleteMigrationSQL returns parameterized SQL to remove a migration record.
	// Parameters: $1=name
	DeleteMigrationSQL(tableName string) string

	// GetAppliedMigrationsSQL returns SQL to get all applied migration names.
	GetAppliedMigrationsSQL(tableName string) string

	// GetLastBatchSQL returns SQL to get the highest batch number.
	GetLastBatchSQL(tableName string) string

	// GetMigrationsByBatchSQL returns parameterized SQL to get migrations for a batch.
	// Parameters: $1=batch
	GetMigrationsByBatchSQL(tableName string) string
}

type MySQLDialect struct{}

type PostgresDialect struct{}