Supporting code includes some SQL tests with scalar subqueries, with
some being correlated and others not.  Also, a buggy materialize-node
implementation for those who want to tinker with making IN/NOT IN
subqueries more efficient -  but the bugs will need to be fixed.