Some of you already know that if you want to get something from database via Symfony you should build a query with help of Criteria() object.
Here is the link to the Symfony book and you can get familiar with this there.
BUT there are only simple queries samples.
What if you need something like this:
SELECT Table1.field1, Table1.field2, Table2.field1 FROM Table1, Table2 WHERE ((Table1.field3=1 OR Table1.field4=1) AND Table1.field5 < 400000) AND Table2.field1=Table1.field1
or smth. like that.
I’ve found useful tool that help you to build such queries 🙂