There are many tokens to tweak queries returning sets or aggregators.
Table Expressions These always have a FROM clause.
SELECT FROM WHERE LATERAL I really battled with using jsonb_each(utility) until I discovered
SELECT key, value FROM tictactoe_states, LATERAL jsonb_each(utility) WHERE id < 10; LATERAL is primarily useful when the cross-referenced column is necessary for computing the row(s) to be joined. A common application is providing an argument value for a set-returning function.