def parse_create_table(sql):
column_types = {}<EOL>for line in sql.splitlines()[<NUM_LIT:1>:]:  <EOL><INDENT>sline = line.strip()<EOL>if not sline.startswith('<STR_LIT>'):<EOL><INDENT>break<EOL><DEDENT>bits = sline.split('<STR_LIT>')<EOL>assert len(bits) == <NUM_LIT:3><EOL>column_name = bits[<NUM_LIT:1>]<EOL>column_spec = bits[<NUM_LIT:2>].lstrip().rstrip('<STR_LIT:U+002C>')<EOL>column_types[column_name] = column_spec<EOL><DEDENT>return column_types<EOL>
Split output of SHOW CREATE TABLE into {column: column_spec}