This, for me, was easiest to try out. And quite impressive, honestly.
The key point was that in each table, the 'title' column (created by default) has a special meaning as they show up in the join columns cleanly.
Amazing and congratulations.
This adoption issue was part of the inspiration for Wax [0] which lets you build internal tools on top of Google Sheets. If your team is already using Sheets, it's much easier to add the missing pieces there vs. pushing people to an entirely separate platform.
In noco we've the concept of primary-value (like primary key) and that shows up automatically when you join with other tables (defaults to 'title'). However the primary value column can be changed to any other column too (by hovering on the column name).
Other tools in the list do not give the smart-spreadsheet automatically when you connect to databases. And frankly, these are two different tools we are comparing.