Help writing SQL query that only lists issues that are assigned to a specific user

[JasoonS]

Firstly, thanks you for this great tool!

I'm definitely not an SQL master and have spent way too long trying to work this out. Maybe you already have a command to do this already prepared?

How can you write a query that only shows issues related to a specific user.

I have tried many variations from this answer for example: https://stackoverflow.com/q/11231544/3103033

I'm probably missing something stupid.

Many thanks 🙏

[KOBA789]

The hard point is that gluesql, on which gh-sql depends, does not provide a handy way to check value existence in an array. (as you know)

Honestly speaking, I have no good ideas to solve this.

Bad news: gluesql hard-codes SQL functions
https://github.com/gluesql/gluesql/blob/d7f8c81b6c575b8bcd39cafcbb5709e55c8d931e/core/src/executor/evaluate/mod.rs#L277-L602

I hope to define a custom function easily... 😢