[BUG] Clean up subquery grammar with `source = [ <subquery> ]`

[vamsimanohar]

we wanted to reserve source= [] syntax for dynamic source selector from the changes here: #4116

Currently, we have unwanted subquery grammar for source clause which we want to remove.