step 1 is stop using that silly Flask extension that gives you
"Pipeline.query", I can't tell what it is you want to SELECT from either by
reading this query.
looks like you have pipeline_alias1 and pipeline_alias2, but you are selecting
from plain Pipeline, nothing is joining to it however.
I've been banging on this for hours, but I seem to be getting nowhere.
I've tried more things that I can count, but here are two of my attempts:
# result = (
#Pipeline.query
# .select_from(Storage, NewProduct)
# .join(Storage, pipeline_alias1.storage_id == Storage.id)
#