Orisnull antipattern: What it is, how to overcome it and how code generation helps

They say that frameworks like Hibernate and Spring Data provide an abstraction over databases. It's easy to use and perfect out of the box. But nothing is perfect, even the databases themselves. Even if there is nothing except for SQL between an application and a database.

For example, to search data by dynamical filter, developers often make queries with where clauses like: where user.name = :name or name is null. Speakers will discuss those queries and how to make them less harmful through code generation.