I can't find the SQL operators exists (and join) in HaskellDB. Are they
not supported yet or have they different names here?
Are nested selects possible?
Basically I need to express in HaskellDB something like:
SELECT DISTINCT store_type FROM stores
WHERE NOT EXISTS (SELECT * FROM cities_stores
WHERE cities_stores.store_type = stores.store_type);
(i.e. asking the question "What kind of store is present in no cities?")
Any hints how to accomplish this in HaskellDB are highly appreciated.