private static void CreateTestView(IQuery query)
{
var tn1 = ObjectName.Parse("APP.test_table1");
query.Access().CreateTable(table => table
.Named(tn1)
.WithColumn("id", PrimitiveTypes.Integer())
.WithColumn("name", PrimitiveTypes.String())
.WithColumn("date", PrimitiveTypes.DateTime()));
query.Session.Access().AddPrimaryKey(tn1, "id");
var exp = SqlExpression.Parse("SELECT * FROM APP.test_table1");
query.CreateView(ObjectName.Parse("APP.test_view1"), (SqlQueryExpression)exp);
}