def METHOD_NAME():
    """
    test dialect options
    """
    b = SchemaBuilder()
    b.add_slot(SlotDefinition("age", range="integer", description="age of person in years"))
    slots = ["full name", "description", "age"]
    b.add_class(DUMMY_CLASS, slots, description="My dummy class")
    b.add_defaults()
    for dialect in ["postgresql", "sqlite", "mysql"]:
        gen = SQLTableGenerator(b.schema, dialect=dialect)
        ddl = gen.generate_ddl()
        if dialect == "postgresql":
            assert "id SERIAL" in ddl
            assert "COMMENT ON TABLE" in ddl
            assert "COMMENT ON COLUMN" in ddl
        if dialect == "sqlite":
            assert "id INTEGER" in ddl
            # sqlite does not support comments
        if dialect == "mysql":
            # TODO: make this test stricter
            # newer versions of linkml-runtime enforce required for identifier slots
            assert "id INTEGER NOT NULL AUTO_INCREMENT" in ddl or "id INTEGER AUTO_INCREMENT" in ddl
            assert "COMMENT" in ddl