Oh, so I just noticed you actually can use raw SQL with streamsql.  So I'll just do that and get rid of this mess.  Happytimes.