Users can specify a WHERE clause.  I have a test case testDataForSQLQuery()  within PhoenixHBaseLoaderIT that validates the results based on the WHERE clause.