Add integration tests

[guyilin-amazon]

We should consider to start adding some integration tests that will compile the executable, exercise the shell with basic transactions like create a table, insert data into a table, select data from a table and drop the table, to verify the shell integrity in addition to current unit tests.