How to handle conditions in API
It looks like you pretty much have it almost done from your screenshot. The where conditions are in the parameters, you have membership_id selected, and you can choose an operator and value for each of the parameters.

Regarding the SELECT col1, col2, col3, if you want to limit to only certain fields you can do that with the "Fields to return" box.