Support scalar functions pushdown to Duckdb with LIMIT.

[myrrc]

As an example, SELECT array_length("GT") FROM statpopgen LIMIT 1 produces
PROJECTION -> STREAMING_LIMIT -> READ_VORTEX query plan which breaks pushdown because
we don't have a PROJECTION -> GET chain.

We need to support this in scalar function pushdown pass and upstream it.