insert query view can take optional leftover