SqlUtil: SQL LENGTH is missing

[alachata-qore]

SqlUtil misses SQL LENGTH function.

[gamato]

I just figured out this little trick that can be used with current SqlUtil:

Instead of:

where length (col_name) <= 10

one could use:

where substr (col, 10+1) is null

:-)

And there is op_substr() in current version of SqlUtil.

[pvanek]

actually SqlUtil misses much more than length()... there are tens of standard functions and hundreds specialized functions in different DBMS. I originally suggested something like op_function(string name, ...args...) which would be expanded to (...args...) call, but it was rejected.

[alachata-qore]

I would suggest op_function(string name, ...args...) again..

[davidnich]

@pvanek the reason it was rejected is because it would directly allow SQL injections