judell · September 10, 2024 20:51
diff --git a/hn_unnest.hcl b/hn_unnest.hcl
 # duckdb

 with names as (
  select
    unnest(string_to_array(?, ',')) as name
 ),

 # sqlite

 WITH RECURSIVE names(name, remaining) AS (
  SELECT
    '',
    ? || ','
  UNION ALL
  SELECT
    substr(remaining, 1, instr(remaining, ',') - 1),
    substr(remaining, instr(remaining, ',') + 1)
  FROM
    names
  WHERE
    remaining != ''
 ),
	# duckdb

	with names as (
	select
	unnest(string_to_array(?, ',')) as name
	),

	# sqlite

	WITH RECURSIVE names(name, remaining) AS (
	SELECT
	'',
	? \|\| ','
	UNION ALL
	SELECT
	substr(remaining, 1, instr(remaining, ',') - 1),
	substr(remaining, instr(remaining, ',') + 1)
	FROM
	names
	WHERE
	remaining != ''
	),