pgsql: Add test coverage for indirection transformation

Add test coverage for indirection transformation

These tests cover nested arrays of composite data types,
single-argument functions, and casting using dot-notation, providing a
baseline for future enhancements to jsonb dot-notation support.

Author: Alexandra Wang <alexandra.wang.oss@gmail.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Discussion:
https://www.postgresql.org/message-id/flat/CAK98qZ1JNNAx4QneJG+eX7iLesOhd6A68FNQVvvHP6Up_THf3A@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/64492917280a1f6227ed9cf43d39095e2cec5cab

Modified Files
--------------
src/test/regress/expected/arrays.out | 26 +++++++++--
src/test/regress/expected/jsonb.out  | 88 ++++++++++++++++++++++++++++++++++++
src/test/regress/sql/arrays.sql      |  7 ++-
src/test/regress/sql/jsonb.sql       | 18 ++++++++
4 files changed, 132 insertions(+), 7 deletions(-)