Issue

Currently the Pyclient implicitly converts CSV data from the get method to a pandas DataFrame (see #4502).
The reliance on the CSV API is problematic for columns with *_array types, as values in these columns are concatenated into a single string instead of separate values in a list.
In addition, with the CSV API it is not possible to expand values from reference and ontology tables.

Solution

The GraphQL API returns values in *_array type columns separately in lists and enables the expanding that is impossible with the CSV API.
In order to implement this the get method requires an additional parameter to specify how the data is requested.

Alternatives

No response

Additional context

The Client developed for EMX1 contained a get method that returned data in a dictionary form and included an expand parameter for its values.