1

I need a tool to simplify queries like:

select usertourna0_.id as id64_0_, usertourna0_.timestamp as timestamp64_0_ from some_table_name usertourna0_ where usertourna0_.id=:p0 and  not (1=0) order by usertourna0_.timestamp desc limit :p1;:p0 = 8570 [Type: Int32 (0)];:p1=123 [Type: Int32 (0)]

to

select t.id, t.timestamp from some_table_name t where t.id=8750 order by t.timestamp desc limit 123

meaning removing not used aliases and redundant conditions, replacing long table alias names like "usertourna0_" with short, specifying parameter values.

It's better to have this as a .NET library but any other app that I can use on Windows is suitable. In case it's not free, the price should be in indie capabilities and the limit depends on other available features.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.