Improve Performance of Partitioned Inserts in Table Functions

Improve performance of partitioned insert into table functions URL, S3, File, HDFS. Closes #34348. #34510 (Maksim Kita).