Is there any way to get something like this into valid sql? Postgresdoesn't like this:
INSERT INTO application (key, creator, name) values ( 1 ,(select userkeyfromuser where username = 'b' ), 'newapplication') ;