I've been playing with DDL abstraction for Drupal. My current idea is to mimic the SQL-92 syntactical structure as an array. I'm working on the assumption that the generic SQL-92 clause ordering is consistent it is only the clauses themselves that need to be translated. I am going to assume that we use mysql datatypes by default so the values in the data definition array will be familar to mysql users.