Yes, I switched it, you’re very right: find() queries whatever you have searched for plus “deleted_at IS NULL”
That’s interesting about NULL being in-indexable, I definitely never knew that. So far I’ve been adding (`deleted_at`, `id`) indexes to all my CI4 tables for models with soft deletes, and often one other like (`deleted_at`, `name`). Does the fact that deleted_at can be null mean these keys are useless? (I’m using MySQL but would like an agnostic solution)
