driver

type ColumnInfo struct {
	Name     string
	Type     string
	Nullable bool
	Default  string
}

type Driver interface {
	Open() (*sql.DB, error)
	Kind() string // "postgres" or "mysql"
	ListObjects(ctx context.Context, db *sql.DB) ([]SchemaRow, error)
	DescribeTable(ctx context.Context, db *sql.DB, table string) (*TableInfo, error)
	// ExplainSQL wraps a user query into an EXPLAIN that returns rows.
	ExplainSQL(sql string, analyze bool) string
}

type FKInfo struct {
	Name       string
	Columns    []string
	RefTable   string
	RefColumns []string
}

type IndexInfo struct {
	Name    string
	Columns []string
	Unique  bool
	Primary bool
}

type SchemaRow struct {
	Schema string
	Name   string
	Kind   string
	Rows   *int64 // approximate, may be nil
}

type TableInfo struct {
	Schema      string
	Name        string
	Columns     []ColumnInfo
	Indexes     []IndexInfo
	ForeignKeys []FKInfo
}