jOOQ with RSQL (FIQL Parser)

  • For statistical queries, nothing comes close to jOOQ due to the dynamic ability to construct SQL queries at runtime.
  • This gives great flexibility in performing dynamic joins and filtering on specific conditions.
  • jOOQ forces you to understand and write the raw SQL implementation, enabling you to optimize queries where necessary
  • Type safety built in to the database columns
select 
"author"."first_name",
"author"."last_name"
from "author"
where (
"author"."first_name" = 'Bert'
or "author"."first_name" in (
'JK', 'John'
)
)

Software engineer at Amazon, DeFi, NFT and Metaverse enthusiast. https://www.linkedin.com/in/john-chang-55a784113/

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Endpoints

Deploying dropwizard java application with Kubernetes and Docker

Orchestrating Azure Functions using BPMN and Camunda — a case study

OmiseGO: Technical Updates, ShinhanCard Proof-of-concept demo, OmiseGO founded Plasma Group…

Branching Models in a nutshell

The Missing Practical Step-By-Step TDD

Linked List Bad Practises

My Developer Origin Story

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
John Chang

John Chang

Software engineer at Amazon, DeFi, NFT and Metaverse enthusiast. https://www.linkedin.com/in/john-chang-55a784113/

More from Medium

HTTPS, TLS (SSL), Key, CSR, CA

Specification first driven API development: consumer protection use-case

Logging Apache Geode Client Queues

Getting Java-11 docker images to run on mac m1 (arm64) with adoptium/temurin