django-sql-dashboard lets you define a SQL query plus one or more text inputs that the user can provide in order to execute the query.
I wanted the user to provide a comma-separated list of IDs which I would then use as input to a
WHERE column IN ... query.
I figured out how to do that using the
unnest() function and
select * from report where id in (select unnest(regexp_split_to_array(%(ids)s, ',')))
ids string passed to this query is split on commas and used for the IN clause.
Here's a simple demo of how
select unnest(regexp_split_to_array('1,2,3', ','))
Created 2021-04-10T16:31:32-07:00, updated 2021-04-13T05:31:43-07:00 · History · Edit