gistfile1.txt

Java:

    public static Field<List<LocationModel>> location(Condition cond) {
        return multiset(
                select(LOCATIONS.ID,
                        LOCATIONS.CHURCH_ID,
                        LOCATIONS.NAME)
                        .from(LOCATIONS)
                        .where(cond)
        ).as("location").convertFrom(r -> r.map(mapping(LocationModel::new)));
    }

Kotlin:

        fun location(cond: Condition?): Field<List<LocationModel>> {
            return multiset(
                select(
                    Locations.LOCATIONS.ID,
                    Locations.LOCATIONS.CHURCH_ID,
                    Locations.LOCATIONS.NAME
                )
                    .from(Locations.LOCATIONS)
                    .where(cond)
            ).`as`("location").convertFrom { r: Result<Record3<Long, Long, String>> ->
                r.map(
                    Records.mapping { id: Long?, churchId: Long?, name: String? ->
                        LocationModel(
                            id,
                            churchId,
                            name
                        )
                    }
                )
            }
        }