LOOKUP vs SELECT and efficiency

[leonrothenberg]

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.

Thx!