The following features are supported for the SELECT statement:

1. Return all columns:
   

   SELECT * FROM Customers

2. Rename a column:
   

   SELECT "CompanyName" AS MY_CompanyName FROM Customers

3. Search data:
   

   SELECT * FROM Customers WHERE Country = 'US';

4. The following operators are supported in the WHERE clause: =.
   

   SELECT * FROM Customers WHERE Country = 'US';

5. Summarize data:
   

   SELECT  MAX(Balance) FROM Customers

6. Retrieve data from multiple tables.
   

   SELECT "Restaurants"."restaurant_id", "Restaurants".name, "Restaurants:Grades".* FROM "Restaurants:Grades" JOIN "Restaurants" WHERE "Restaurants".name = 'Morris Park Bake Shop'

   See JOIN Queries for details.