Please improve the Filter query widget in WAB to allow custom SQL queries and port it over to Experience Builder. Values must auto-filter based on the previous query statement. A proper UI like Select by attributes in ArcMap or ArcGIS Pro would be ideal.
There was a Select by attributes widget developed by a user but it's been a while since he replied.
Select by Attributes Widget v1.1 07/20/2018 - Esri Community
ArcGIS Web Application (adrisolid.github.io)
or somebody please help improve this