I need to build tables like in the picture, it turns out to be a very complex structure where I understand what relationships need to be used, but I don’t understand how to do it
example pic

Let’s say I have a db of Customers. I want to fetch data and filter rows by exact pairs.

I have two tables component and component_transform

I’m trying to update a table with info from some other rows from the same table. However, I cannot get SQLAlchemy to generate the proper SQL. It always ends up with a WHERE false clause in the subquery, which nullifies the effect.

I’m using the following code to execute a SQL stored procedure from Python. The stored procedure in question iterates over a number of different insert statements contained in another table. However, when ran from Python, the stored procedure doesn’t iterate over the complete set of data.

I’m looking to replicate a SQL query I’ve been using in pgAdmin to join multiple tables and download the resulting table into a CSV file. I’ve been successful with pgAdmin and want to achieve the same result using SQLAlchemy, as my application interacts with the database through SQLAlchemy.