add more test cases for different types of queries
support parameterized value in query