While it's unfortunate that you didn't get the gig, you do have something: the knowledge that when you go for another job of this type and get a similar question, the words "temp tables" will not feature in your reply, at least not in a positive way.