[sqlalchemy] Why no Raw Query Builder?

2013-08-03 Thread Taba Taba
Hi all, I switch from php to python I'm using Codeigniter Query Builder: $this-db-select('*'); $this-db-from('blogs'); $this-db-join('comments', 'comments.id = blogs.id'); $this-db-limit(10, 20); $query = $this-db-get(); // Produces: // SELECT * FROM blogs // JOIN comments ON comments.id =

Re: [sqlalchemy] Adding properties of wrapped object to association proxy

2013-08-03 Thread Michael Bayer
On Aug 2, 2013, at 2:32 PM, Ams Fwd ams@gmail.com wrote: Hi All. Is there any way to transparently add the properties of the associated object to the association proxy? For e.g. if I have the following setup class UserModel(Base): name = sa.Column(sa.String(512)) orgs =

Re: [sqlalchemy] Why no Raw Query Builder?

2013-08-03 Thread Michael Bayer
On Aug 3, 2013, at 12:34 PM, Taba Taba betak...@gmail.com wrote: Hi all, I switch from php to python I'm using Codeigniter Query Builder: $this-db-select('*'); $this-db-from('blogs'); $this-db-join('comments', 'comments.id = blogs.id'); $this-db-limit(10, 20); $query = $this-db-get();