Optimizers cannot optimize columns with certain TypeMapper:s

[minborg]

If a column has a TypeMapper that does not preserve the order between the original database type and the Java type, then an Optimizer cannot render the column to an ORDER BY operation directly.

The same problem will occur for certain filters (e.g. .greaterThen()) where the order is not retained over the TypeMapper. So these particular operations cannot be rendered to a WHERE statement.

There must be a way for an Optimizer to know if a TypeMapper preserves order.

It could be possible to describe a SQL mapping to apply, so that the order could be retained. However, it is difficult in the general case.