> So maybe your wizard should be improved, but I don't think anything
> should change in Firebird to adjust it to programs using Firebird in

an

> inappropriate manner.

Interesting perspective (the wizard thing is just a straw man u
realize that). Maybe we should start writing execution plans directly,
instead of SQL to better adapt to the optimizer. Being sensitive to
the order of AND operands in an expression, not pre-evaluating
constant expressions and so forth are just shortcomings of the
optimizer, whatever side you turn it, whatever difficult is to
implement it, whatever the incentive to implement it or not. But not
accepting this as a fact is detrimental to the attitude of improving
the damn thing.

Sorry for the bad poison I just had to spit it out.