def METHOD_NAME(names, float_names, int_names):
    """Convert list of names to SQL column definition
    Creates definition of columns for an SQL statement.
    Non-compliant names are fixed.
    The original names are assumed to be unique.
    """
    sql_columns = []
    bad_name_prefix = "col_"
    for name in names:
        if name in float_names:
            sql_type = "REAL"
        elif name in int_names:
            sql_type = "INTEGER"
        else:
            sql_type = "TEXT"
        # Catch and fix SQL non-compliant names.
        old_name = name
        name = make_name_sql_compliant(name, fallback_prefix=bad_name_prefix)
        if name != old_name:
            gs.verbose(_("Renaming <{old_name}> to <{name}>").format(**locals()))
        sql_columns.append((name, sql_type))
    # Format as "name1 type1,name2 type2".
    sql_columns = [" ".join(column) for column in sql_columns]
    return ", ".join(sql_columns)