Ecto query filter from map

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.