Great - thanks. I’ll do that, or set defaults in the database.
I’ve come across similar issues before with sorting, but didn’t realise it could affect displayed data. It would be a good idea if some warning was displayed or popped up, in query builder perhaps, to warn about this. I think you mentioned it was performance related, but it has rather serious potential consequences.