I’m tiring to allow the user to populate the select clause from as saved list or list box.  I’m hoping to be able to pass a list into the Select or Where clause as needed.   Myview coll = new myview(); List<object> myList = new List<object>   //logic to add column names ...

Your local help file that EntitySpaces installs already reflects the additions of SubOperators to queries. Additionally, the Quick Reference shows syntax and usage.

With the .As() can we do complex aliasing like                     sqlText = ''SELECT Title +' '+ Name as CNAME, Premises+', '+House+', '+Address AS A1, Area+', '+City AS A2, County+' '+PostCode AS A3, Completed, Date, AppointmentID '' ...

Please see here