async def METHOD_NAME(
    connection: SAConnection, *, gid: int, product_name: str
) -> GroupExtraProperties:
    get_stmt = sa.select(groups_extra_properties).where(
        (groups_extra_properties.c.group_id == gid)
        & (groups_extra_properties.c.product_name == product_name)
    )
    result = await connection.execute(get_stmt)
    assert result  # nosec
    if row := await result.first():
        return GroupExtraProperties.from_row(row)
    raise GroupExtraPropertiesNotFound(f"Properties for group {gid} not found")