So I guess my only option is to loop through and write the sql myself, oh well I guess it will keep my sql up to scratch.

It kinda pisses me off that a lot of this technology seems to be dependant on interfacing with MS products only.