public void Postgres()
{
var compiler = new PostgresCompiler();
var helper = compiler.GetHelper();
var query = new Query()
.From(new Query("category_translations").As("t"))
.Join(new Query("categories").As("c"), j => j.On("c.Id", "t.CategoryId"))
// فعلا سطح اول
.Where("c.ParentId", Guid.Empty)
.Where("t.Culture", "fa")
.Where("c.Visible", true)
.Select("t.Id as TranslationId", "t.Title", "t.Subtitle", "t.Thumbs");
var queryString = compiler.Compile(query);
query = new Query()
.From(new Query("table").As("table_alias"))
.Select(helper.Select.NoAlias <TableModel>(false, "table_alias", "Password"));
queryString = compiler.Compile(query);
var c2 = new SqlServerCompiler();
var h2 = c2.GetHelper();
var query2 = new Query()
.From(new Query("table").As("table_alias"))
.Select(h2.Select.NoAlias <TableModel>(false, "table_alias", "Password"));
var s2 = c2.Compile(query2);
}