Admin database to connect to for CREATE/DROP DATABASE operations

• PostgreSQL: Some "postgres"
• MariaDB: Some "mysql"
• SQLite: None (file-based, no admin DB)

SQL to check if database exists Returns query string with one parameter placeholder

• PostgreSQL: SELECT EXISTS(SELECT 1 FROM pg_database WHERE datname = $1)
• MariaDB: SELECT SCHEMA_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = ?
• SQLite: "" (N/A - use file system check instead)

Generate SQL to create database

• parameter db_name

  Database name to create

• returns

  SQL statement (not parameterized - database names can't be)

Generate SQL to drop database

• parameter db_name

  Database name to drop

• returns

  SQL statement (not parameterized - database names can't be)

Convert timestamp column to string in SELECT

• parameter column_name

  Name of timestamp column

• returns

  SQL expression that casts to string

  • PostgreSQL: "created_at::text"
  • MariaDB: "CAST(created_at AS CHAR)"
  • SQLite: "created_at" (auto-converts)

Whether this dialect supports CREATE/DROP DATABASE SQLite is file-based, so it uses file operations instead