Observable

Paul Buffa

How would you do this with the SQL IN operator to select multiple nationalities?

... WHERE artists.Nationality  IN  (${selectNationality}) ...

observable seems to surround javascript strings with quotes when converting to sql, and it does the same thing for lists, but then the query doesn't work, because lists have a sequence of quotes, and I've been tinkering with it, but haven't gotten it to work.

On another note, are you aware of any forum for observableHQ to escalate questions?

George Tang

Hey George,

You could pass in an array, like how this notebook handles it, for doing multiple values at once: https://observablehq.com/@observablehq/mix-queries-and-arrays-into-sql?collection=@observablehq/observable-tips-and-tricks

And yes! There is a forum that is a great spot to ask these sorts of questions. https://talk.observablehq.com/