[smt88]

> Does Retool have a query builder?

Yes. It may not be exactly like the one in Airforms. You can do CRUD operations/mappings without writing any SQL, or you can drop into SQL (with autocomplete and a schema browser) if you need more complexity.

> Does it support query parameters?

Yes.

> Does it support displaying fields from lookup tables (i.e., tables joined via foreign key)?

Yes.

> How do you pick a record from a foreign table (when you want to update the foreign key itself)?

There are multiple ways to do it. The easiest way is to run a query to get the IDs (and labels) from the table you're joining and then add that to some kind of input (list, table, etc.)

Like I said in a previous comment, a lot of this stuff requires knowing how to code or at least some technical understanding of databases, which might be a differentiator.