Filter Date order is important

[hypersurge]

A Filter with Date > Field creates "Cannot compare Date and tink.sql.Field<Date,...>", whereas flipping the order to Field < Date completes as expected. Same with ==. The issue did not present on Int and VarChar fields.

The workaround is easy enough so this little note is probably enough to help others avoid the issue.

[kevinresol]

I wonder why though. Because even for Float there are only Field <op> Float operator overloads but not Float <op> Field, so I expect this will work only one way but the other way round:

tink_sql/src/tink/sql/expr/Field.hx

Line 152 in 097c652

@:op(a <= b) static function lteConst<T:Float, S>(a:Field<T, S>, b:T):Condition