GNATCOLL.SQL.SQL_Select - I'm in Left_Join hell

["Thomas Løcke" <thomas@12boo.net>]

Hey all,

I'm hoping some GNATCOLL.SQL specialist can help me write a SQL_Select
call that isn't as horribly ugly as the one I've currently come up with.

The SQL query I'm frantically trying to create is this:

https://gist.github.com/2421273

A fairly straightforward query with a bunch of JOIN's. Nothing overly
complicated and very easy to read.

Next lets take a look at the GNATCOLL.SQL.SQL_Select call I've come up
with:

https://gist.github.com/2421241

It is, IMHO, very unreadable with all those nested Left_Join calls. Is
there a better/prettier way, without falling back to embedding an SQL
string in the Ada source?

The SQL generated by the above SQL_Select call works fine, it's just
that I'm finding it very hard to read.

Any and all suggestions are more than welcome!

:o)

-- 
Thomas L�cke | thomas@12boo.net | http://12boo.net