Thank you, I wasn’t aware that dynamic can be used like that. That’s really useful. Having said that, now I’m stuck with the case of startswith
. Originally I had
"startswith" -> dynamic([q], like(field(q, ^String.to_atom(name)), ^"#{val}%"))
but would also like that to support the self.
syntax in that case. So in SQL
SELECT * FROM items WHERE control LIKE comment || '%';
I can’t concat a dynamic and a string, so I’m not sure how to achieve this.