Thanks for the response! I just came back to say that it works now.
Fooling around with some other stuff, I added a form to the app and clicked the 'generate' link. It showed an error and gave a button to reload the page, which I clicked. It then took me back to the app with a working table.
I had run the query multiple times before, without any luck. Must have been some weird bug?