Discussion: should set FileScanConfig's batch_size to min(batch_size, limit)

If a limit is set for FileScanConfig, I wonder if it's reasonable to also set the batch_size to min(batch_size, limit), which might reduces the number of rows being scanned and decoded.

Originally posted https://github.com/apache/arrow-rs/issues/8836

Start by tracing FileScanConfig and how its batch_size and limit are applied, then read the linked apache/arrow-rs issue 8836 for context. The issue is a discussion rather than a defined task, so completion depends on agreeing whether batch_size should be bounded by limit and documenting the resulting behavior and tests.

Written by the indexing model from the issue text.