How to effectively write long queries?

[Mathieu Cassagnes]

Is there a preferred method for writing long queries?

So far I've been writing long queries with string concatenations, like this:

"select a.*, b.name, c.title "

"from tableA a, tableB b, table C c " + 

"where a.id = b.id " + 

"and a.id = c.id " + 

"limit 1"

Writing 20+ lines queries gets tedious, is there a better way to do this?

Thanks,

Math

[00a5]

I've written my own query builder. I would suggest making one so there's no code duplication and it'll make the code easier to understand and edit