1) Show all the virtual tables supported:  

   show tables

2) Print the table's description for the UserTable's table

   describe UserTable

3) Basic select query 

   set query latest
   select Name,Latitude,Longitude from Site

4) Continuos select query for the Site's table

   set query continuous
   set maxage 1 days
   set timeout 10 seconds
   select * from Site

5) Insert e Select using Continuos + History query

   set producer continuous
   insert into UserTable values ('cod','string',1.4,66)
   set query continuous
   set maxage 1 minutes
   set timeout 5 seconds
   select * from UserTable 

6) Insert e Select using the Secondary Producer to support the latest query
        
   set secondaryproducer latest
   secondaryproducer UserTable
   set producer continuous
   insert into UserTable values ('cod','string',5.2,44) 
   set query latest
   select * from UserTable

7) Show a list of producers for a table.

   set producer continuous
   insert into UserTable values ('cod','string',8.2,33) 
   show producers of UserTable