>I want the expressiveness of SQL queries within a single Excel file, so that data entry and derived views are within the same tool and same file.

There is at least 1 tool that can run SQL within Excel. I forget the name. You can probably find it via Google.

>Also, EDT doesn‘t look like it can do joins?

Easy Data Transform can absolutely do Joins (plus 58 other transformations).