Changes for version 1.63 - 2023-02-23

  • sqlt-diff: Change producer_args to sqlt_args for better self-documentation NOTE - using producer_args will now throw a deprecation warning
  • A lot of new functionality for the Oracle producer (thanks @hazardv)
  • Support DB commments in the following producers: PG, JSON, YAML. Also in the sqlite parser (thanks @djerius)
  • Support INCLUDE on indices for Pg (producer + parser)
  • Postgres producer now supports materialized views via $extra->{materialized}
  • Postgres producer genrates correct constraint names for schema-namespaced tables
  • Postgres DBI parser now returns scalarref SQL instead of strings for defaults (thanks @nrdvana)
  • Postgres producer drops NOT NULL constraints more correctly (thanks @uehara-delta)
  • binaries now have their perl set by EUMM (thanks @toddr)


sqlfairy user manual
convert SQL schema using SQL::Translator
Automatically create a diagram from a database schema
find the differences b/w two schemas
find the differences b/w two schemas
create a dumper script from a schema
Automatically create a graph from a database schema


manipulate structured data definitions (SQL and more)
determine differences between two schemas
Set default extra data values for schema objects.
Add global fields and indices to all tables.
Tweak the names of schema objects.
A Moo based MySQL DDL generation engine.
A Moo based PostgreSQL DDL generation engine.
A Moo based MS SQL Server DDL generation engine.
A Moo based SQLite DDL generation engine.
Role implementing common parts of DDL generation.
Role for dealing with identifier quoting.
describes how to write a parser
parser for Access as produced by mdbtools
"parser" for DBI handles
parser for DBD::DB2
parser for DBD::mysql
parser for DBD::Oracle
parser for SQL Server through DBD::ODBC
parser for DBD::SQLite
parser for DBD::Sybase
Parse a JSON representation of a schema
parser for PostgreSQL
parser for SQL Server
parser for Schema objects serialized with the Storable module
Alias to XML::SQLFairy parser
parser for SQL::Translator's XML.
Parse a YAML representation of a schema
parser for arbitrarily delimited text files
describes how to write a producer
create Class::DBI classes from schema
ER diagram producer for SQL::Translator
SQL Dumper producer for SQL::Translator
GraphViz producer for SQL::Translator
HTML producer for SQL::Translator
A JSON producer for SQL::Translator
MySQL-specific producer for SQL::Translator
Oracle SQL producer
POD producer for SQL::Translator
PostgreSQL producer for SQL::Translator
MS SQLServer producer for SQL::Translator
SQLite producer for SQL::Translator
serializes the SQL::Translator::Schema object via the Storable module
Sybase producer for SQL::Translator
TT (Template Toolkit) based Producer base class.
Alias to XML::SQLFairy producer
SQLFairy's default XML format
A YAML producer for SQL::Translator
Remove undefined constructor arguments
Error setter/getter for objects and classes
context-sensitive list attributes
SQL::Translator schema object
SQL::Translator constraint object
SQL::Translator field object
SQL::Translator index object
Base class for SQL::Translator schema objects
SQL::Translator procedure object
"extra" attribute for schema classes
SQL::Translator table object
SQL::Translator trigger object
SQL::Translator view object
Type checking functions
SQL::Translator Utility functions
Test::More test functions for the Schema objects.


in lib/SQL/Translator/Parser/DB2/
in lib/SQL/Translator/Parser/DB2/
in lib/SQL/Translator/Role/
in lib/SQL/Translator/