Victor,
Thanks for your detailed explanation! It all makes sense now.
I was mainly using the help page below for reference. It would be nice if it had a note explaining that distinction between the built-in select statement and gsql select statement.
https://docs.tigergraph.com/dev/gsql-ref/querying/select-statement#gsql-select-statement