my problem above with positions could also have been solved by hugsql.parameters/apply-hugsql-param and using two params types.
The problem is the Hugsql at the moment loses the type information in the data. Even if my params are marked with :bytea-stream:content type in the query, I then lose that type and see only :content in the defmethod call