title: Is there any easier way to convert a string that looks like a list in DuckDB than regexp_split_to_array or string_split?
body: <p>I am attempting to query a Pandas Dataframe with DuckDB that I materialize with <a href="https://pandas.pydata.org/docs/reference/api/pandas.read_sql_query.html" rel="nofollow noreferrer">read_sql_query</a>.</p>
  <p>Some of this data is stored in a JSON format and in the target column each value has a list of items - [&quot;Value1&quot;, &quot;Value2&quot;, &quot;Valueetc&quot;] that from the point of view of DuckDB is just a VARCHAR column.</p>
  <p>My goal was to convert the string that looks like a list to an actual list in the DDB context -</p>
  <pre><code>STRING_SPLIT(REPLACE(REPLACE(REPLACE(ColumnName, '&quot;',''),'[',''),']',''),',') AS ColumnName
  </code></pre>
  <p>I can definitely remove the quotes and brackets and return a list with this approach but I was hoping there's a less ugly/more idiomatic way to accomplish the goal.</p>