<dependency> <groupId>org.jooq</groupId> <artifactId>jooq</artifactId> <version>3.14.5</version> </dependency> DSLContext context = DSL.using(connection, dialect); Result<Record> result = context.select() .from(Tables.AUTHOR) .where(Tables.AUTHOR.ID.eq(1)) .fetch();