On Thursday, March 28, 2019 at 6:27:52 PM UTC-4, Mike Bayer wrote: > > > is this some standard thing you're both doing? I didn't see anything > about joins or query analyzing. you often have answers for > questions where I don't understand what theyre asking! >
Well his question and the example code look a lot of some things i've encountered before... so I'm fairly confident I know what he's intending to do on a higher level (vs what he's actually doing in this code). I've had to do similar things where you allow "website users, usually marketing / audience / analytics" select a handful of metrics to generate a custom report. in his example, it's clear to me these 3 'metric' items respond to the table/columns... formula = '"metric:123" + "metric:456" + "metric:789"' SELECT post.id + campaign.id + asset.id FROM post, campaign, asset so then there's got to be a way to join the 3 tables together. you actually helped me on something similar a long time ago... and I think there's still an open ticket or two in the SqlAlchemy backlog regarding this. I was trying to inspect dynamically build queries to figure out if a table was joined yet or not or if a column was already queried. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
