def METHOD_NAME(session: Session, fuel_type_abbrev: str):
    res = session.query(fuel_types_table) \
        .filter(fuel_types_table.c.abbrev.ilike(f'{fuel_type_abbrev}%%'))
    return int(res.first().id)