创建一个函数来返回表SQL

def generate_create_table_sql(table_name, columns):
    sql = f"CREATE TABLE {table_name} (\n"
    for column in columns:
        sql += f"    {column['name']} {column['type']}"
        if 'length' in column:
            sql += f"({column['length']})"
        if 'default' in column:
            sql += f" DEFAULT {column['default']}"
        if 'not_null' in column and column['not_null']:
            sql += " NOT NULL"
        if 'primary_key' in column and column['primary_key']:
            sql += " PRIMARY KEY"
        sql += ",\n"
    sql = sql.rstrip(",\n") + "\n)"
    return sql

table_name = "users"
columns = [
    {
        "name": "id",
        "type": "INT",
        "not_null": True,
        "primary_key": True
    },
    {
        "name": "name",
        "type": "VARCHAR",
        "length": 50,
        "not_null": True
    },
    {
        "name": "email",
        "type": "VARCHAR",
        "length": 100,
        "not_null": True
    }
]

create_table_sql = generate_create_table_sql(table_name, columns)
print(create_table_sql)

CREATE TABLE users (
    id INT NOT NULL PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL
)