Re: [sqlalchemy] orm.column_property()

2023-06-23 Thread Mike Bayer
On Fri, Jun 23, 2023, at 9:38 AM, Julien Cigar wrote: > On Fri, Jun 23, 2023 at 09:29:27AM -0400, Mike Bayer wrote: >> >> Hi Julien - > > Hi Mike, > >> >> OK, if we're going to do one of your big queries, can we please start fresh, >> make a new discussion at >>

Re: [sqlalchemy] orm.column_property()

2023-06-23 Thread Julien Cigar
On Fri, Jun 23, 2023 at 09:29:27AM -0400, Mike Bayer wrote: > > Hi Julien - Hi Mike, > > OK, if we're going to do one of your big queries, can we please start fresh, > make a new discussion at https://github.com/sqlalchemy/sqlalchemy/discussions > , give me **really really succinct** models

Re: [sqlalchemy] Problems with multiple consecutive joins

2023-06-23 Thread Mike Bayer
hi - same as the other message I just answered here, nobody can tell what would be wrong with this query without a runnable example, please post **very succinct** sample classes + the query you are seeking at https://github.com/sqlalchemy/sqlalchemy/discussions On Fri, Jun 23, 2023, at 6:10

Re: [sqlalchemy] orm.column_property()

2023-06-23 Thread Mike Bayer
Hi Julien - OK, if we're going to do one of your big queries, can we please start fresh, make a new discussion at https://github.com/sqlalchemy/sqlalchemy/discussions , give me **really really succinct** models + the query you want, etc. the google groups thing here is not exactly going

Re: [sqlalchemy] orm.column_property()

2023-06-23 Thread Julien Cigar
On Fri, Jun 23, 2023 at 10:48:27AM +0200, Julien Cigar wrote: > > On Wed, Jun 21, 2023 at 08:35:36AM -0400, Mike Bayer wrote: > > > > > > > > On Wed, Jun 21, 2023, at 5:12 AM, Julien Cigar wrote: > > > Hello, > > > > > > I'm trying to add a column_property to recursively load and merge some >

[sqlalchemy] Problems with multiple consecutive joins

2023-06-23 Thread Piotr
I have a problems with a CTE query using multiple consecutive joins (A -> B -> C -> D). A and B have both relation to other table so they are joined by that other_id value. C has FK to B and C-D are One to One (id=id). The query looks like so: latest_message = (session.query(

Re: [sqlalchemy] orm.column_property()

2023-06-23 Thread Julien Cigar
On Wed, Jun 21, 2023 at 08:35:36AM -0400, Mike Bayer wrote: > > > > On Wed, Jun 21, 2023, at 5:12 AM, Julien Cigar wrote: > > Hello, > > > > I'm trying to add a column_property to recursively load and merge some > > json column. > > > > I have the following: > >