In Grist, reference columns let you do a lot of what you can do with a join https://support.getgrist.com/col-refs/ https://support.getgrist.com/col-refs/ while

In Grist, reference columns let you do a lot of what you can do with a join https://support.getgrist.com/col-refs/ https://support.getgrist.com/col-refs/ while still having spreadsheet-style immediate updates when underlying data changes. Also, if you just want to do queries and don't care about instant updates, you can do any SQL you like including joins with a SQL endpoint or a custom widget https://twitter.com/getgrist/status/1710018836836077967 https://twitter.com/getgrist/status/1710018836836077967 [Grist employee]