[R] Datasets API interface improvements

[asfimport]

Umbrella ticket for improvements for our interface to the datasets API, and making the experience more consistent between open_dataset() and the read_*() functions.

The current parameters which are supported in read_delim_arrow() but not in open_dataset are:

• file

• col_names

• col_select

• na

• quoted_na

• parse_options/convert_options/read_options*

• as_data_frame

  Subtasks 2, 5, 6, 7, 8, and 10 below allow us to support all of the read_csv_arrow() options in open_dataset() for CSVs, or give helpful error messages when options aren't supported.

Reporter: Nicola Crane / @thisisnic

Subtasks:

• [R] Allows user to specify string to be used for missing data when writing CSV dataset
• [R] Allow user to supply col_names argument when reading in a CSV dataset
• [R] passing a schema calls open_dataset to fail on hive-partitioned csv files
• [R] CsvConvertOptions include_columns and col_select should give better error message when used in open_dataset
• [R] Update read_csv_arrow and open_dataset parse_options, read_options, and convert_options to take lists
• [R] Update function examples to show how to open CSV dataset with partitioning and a schema
• [R] Misleading error message if opening CSV dataset with invalid file in directory
• [R] Improve error message when providing a mix of readr and Arrow options
• [R] Better document the CSV read/parse/convert options we can use with open_dataset()
• [R] support the quoted_na argument in open_dataset for CSVs by mapping it to CSVConvertOptions$strings_can_be_null
• [R] Handle as_data_frame argument if passed into open_dataset for CSVs
• [R] support parse_options, read_options, convert_options in open_dataset to mirror read_csv_arrow
• [R] Implement new function open_dataset_csv with signature more closely matching read_csv_arrow

_{Note: This issue was originally created as ARROW-18352. Please see the migration documentation for further details.}