Fun with JOOQ (sadly without codegen)

ServiceRepository.java

    @Override
    public Collection<Service> findAllByEnvironmentWithinDuration(Environment environment, Duration duration) {
        return DSL.using(dataSource, dialect)
                .select(field("s.name", field("s.pattern"), field("a.name"), field("e.name")))
                .from(table("service").as("s"))
                .leftOuterJoin(table("application").as("a"))
                .on(field("s.application_id").equal(field("a.id")))
                .leftOuterJoin(table("environment").as("e"))
                .on(field("a.environment_id").equal(field("e.id")))
                .where(field("s.creation_time_millis").minus(duration.get(MILLIS)).greaterThan(0))
                .and(field("e.name").equal(environment.getName()))
                .fetch(rec -> {
                    Environment env = new Environment(rec.getValue("e.name", String.class));
                    Application app = new Application(env, rec.getValue("a.name", String.class));
                    return new Service(
                            app,
                            rec.getValue("s.name", String.class),
                            rec.getValue("s.pattern", String.class)
                    );
                });

    }