feat(python): Reduce scan_csv() (and friends') memory usage when using BytesIO

feat(python): Reduce scan_csv() (and friends') memory usage when using BytesIO #18955