Hi all - just 2 style/clarification questions about overlapping functionality:
LOOKUP() vs. SELECT() ?
INDEX(SELECT( … ), 1) vs ANY(SELECT( … )) when you’re sure there’s only one result, and it needs to be typecast as its type, not as a returned LIST.
Interested in some guidance both in efficiency and best use cases. Any advice appreciated.