Add table_options function to use with visit_create_table

Hi, I'm implementing a dialect for sqlalchemy and would like to add options to my CREATE TABLE DDL before the '(' but after the table name in visit_create_table. I know I can just subclass visit_create in my ddl compiler but it seems kind of silly since I'd be making a small change.

table_options would be a function in the ddl compiler provided by the dialect that takes dialect specific keywords and simply appends comma delimited values.

1 files changed, 4 insertions, 1 deletions

diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py
index 3d2f02006..3567427a7 100644
--- a/lib/sqlalchemy/sql/compiler.py
+++ b/lib/sqlalchemy/sql/compiler.py
@@ -2216,7 +2216,7 @@ class DDLCompiler(Compiled):
         text = "\nCREATE "
         if table._prefixes:
             text += " ".join(table._prefixes) + " "
-        text += "TABLE " + preparer.format_table(table) + " ("
+        text += "TABLE " + preparer.format_table(table) + " " + self.table_options(table) + " ("
 
         separator = "\n"
 
@@ -2421,6 +2421,9 @@ class DDLCompiler(Compiled):
             colspec += " NOT NULL"
         return colspec
 
+    def table_options(self, table):
+        return ''
+        
     def post_create_table(self, table):
         return ''