const string sql = """
    SELECT
        a.id AS Id,
        a.last_modified_date_on_utc AS LastModifiedDateOnUtc,
        a.last_modified_by AS LastModifiedBy,
        a.created_on_utc AS CreatedOnUtc,
        a.created_by AS CreatedBy,
        a.type_of_request AS TypeOfRequest,
        a.customs_clearance AS CustomsClearance,
        a.delivery_conditions AS DeliveryConditions,
        a.cargo_readiness_period AS CargoReadinessPeriod,
        a.deadline_for_submitting_commercial_offer AS DeadlineForSubmittingCommercialOffer,
        a.type_of_cargo AS TypeOfCargo,
        a.type_of_packaging AS TypeOfPackaging,
        a.container_type AS ContainerType,
        a.places_in_container AS PlacesInContainer,
        a.loading_in_one_container_net AS LoadingInOneContainerNeT,
        a.number_of_containers AS NumberOfContainers,
        a.weight_of_one_place AS WeightOfOnePlace,
        a.loading_per_container_gross_ton AS LoadingPerContainerGrossTon,
        a.port_of_shipment AS PortOfShipment,
        a.transshipment_port AS TransshipmentPort,
        a.place_of_delivery AS PlaceOfDelivery,
        a.cargo_pickup_address AS CargoPickupAddress,
        a.note AS Note,
        a.is_visible AS IsVisible,
        a.index AS Index
    FROM transportation_request AS a
    """;

var transportationRequestResponse =
    await connection.QueryAsync<(Guid, string, bool), TypeOfRequest, Audit, LogisticsProcess, CargoCharacteristics, CharacteristicsOfTheContainer, LogisticsHubs, GetTransportationRequestResponse>(
        sql,
        (auxiliaryParameters, typeOfRequest, audit, logisticsProcess, cargoCharacteristics, characteristicsOfTheContainer, logisticsHubs) =>
        {
            return new GetTransportationRequestResponse(
                auxiliaryParameters.Item1,
                audit,
                typeOfRequest,
                logisticsProcess,
                cargoCharacteristics,
                characteristicsOfTheContainer,
                logisticsHubs,
                auxiliaryParameters.Item2,
                auxiliaryParameters.Item3);
        },
        splitOn: ("Id", "Note", "IsVisible"), "TypeOfRequest", "LastModifiedDateOnUtc", "TypeOfRequest", "ContainerType", "PortOfShipment");