I want to do an advanced search, something similar to the one in
scryfall where I can use either syntax or buttons to search, using multiple filter and logical operators. I have difficulty knowing how to create the SQL query dynamically. If it’s possible I’d like to …