Antipattern orisnull: the Intrigue of illusory simplicity

They say, that frameworks like Hibernate and Spring Data provide an abstraction over databases. Easy to use, 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 clause like : where user.name = :name or name is null We will discuss those queries and how to make them less harmful with code generation.