from typing import Dict


def _map_dtypes(sql_dtypes: Dict[str, str]) -> Dict[str, type]:
    """
    Create mapping from SQL data types to Python data types.

    :param sql_dtypes: A mapping from the column names in a SQL table
        to their respective SQL data types.
        Example: {"ct_id": int(10) unsigned NOT NULL AUTO_INCREMENT}
    :type sql_dtypes: Dict[str, str]
    :return: A mapping from the column names in a SQL table
        to their respective Python data types. Example: {"ct_id": int}
    :rtype: Dict[str, type]
    """

    types: Dict[str, type] = {}
    for key, val in sql_dtypes.items():
        if "int" in val:
            types[key] = int
        elif any(dtype in val for dtype in ("float", "double", "decimal", "numeric")):
            types[key] = float
        else:
            types[key] = str
    return types