Any particular reason why scalar list filters is only supported for postgres?

Because postgres supports them natively. MySQL and SQLite don't.