def METHOD_NAME(self, path: DbPath) -> str:
    """Provide SQL for selecting the table schema as (name, type, date_prec, num_prec)"""
    database, schema, name = self._normalize_table_path(path)
    info_schema_path = ["information_schema", "columns"]
    if database:
        info_schema_path.insert(0, database)
    return (
        "SELECT column_name, data_type, datetime_precision, numeric_precision, numeric_scale "
        f"FROM {'.'.join(info_schema_path)} "
        f"WHERE table_name = '{name}' AND table_schema = '{schema}'"
    )