I'm working in a project to add Fuzzy query capabilities to HQL.
http://en.wikipedia.org/wiki/FSQLI'm trying to extending HQL in the following way:
- Create new tokens, like FEQ.
- Rendering sql from this token.
Example:
FEQ is a binary operator
HLQ:
select c from Car c where c.colour FEQ 254;
I want to render something like this into SLQ:
select c from Car c where ((c.colour = 254) OR ((c.colour >250) AND (c.colour<260)));
I want to do this without generating a new hql grammar and compiling hibernate source.
Any ideas?