Presently, an AvoidLeased flag is meant to indicate that leased descriptors should not be used. This flag, unfortunately, is never used by the resolver when looking up objects, and it could lead to bugs in the future. To avoid problems and mitigate any risks, we will refactor the code to replace this flag instead with an assertion, which guarantees to the caller that the look-up is properly configured to avoid leased descriptors in a context.

Jira issue: CRDB-30608