Hi there! I agree screenshots could be helpful if you're able to share 
TLDR how to make it so when I create a new row in my address table it automatically takes the new address id and adds it to the appropriate row in the project table ?
It sounds like you may need to write multiple queries and chain them together on success. Your first insert or update query may return some helpful data about the recently inserted record in the .data property that you can reference in subsequent queries
-At the same time when performing a query to load date in a retool table, retool combines the keys used in the join condition into an array.Is it possible to avoid that behaviour ?
I'm not quite sure I'm following this question yet. Are you looking to remove certain properties from an array? If so, you may be able to use lodash's pick - like this example