Yes, you can. You just enter a url, and put the %s somewhere in the query params which firefox will replace with your query.
I just tested this with my own website, which definitely does not support any OpenSearch standard, and it works exactly like you’d imagine (except the page doesn’t exist of course).
Edit: nevermind, turns out this is a librewolf thing. Sorry about that