Jeff Garland wrote:
Maciej Sobczak wrote:
Hi,
Jeff Garland wrote:
Well, I'll be brutally honest -- I don't think I would go that direction. We didn't pick a database project last year because a majority of the mentors agreed that the 'dsl-based' approach was more of a toy than reality. The main reason for this is that in 'real-world' applications queries are often dynamic and must be built at run-time.
The other reason is that in 'real-world' you might want to call stored procedures instead of manually glued pieces of ad-hoc SQL queries, in which case the support in the area of query composition is probably not very useful anyway.
True, but I wouldn't recommend it since it's inherently non-portable.
Portability is another reason to go away from sql queries as strings. -Thorsten