db.from(Blog).Where(b=>b.Title == "Hello World!") 
//select * from Blog where Title = 'Hello World' 

//选择部分列
db.from(Blog).Where(b=>b.Title == "Hello World!").Select(b=>b.Id)
//select Id where Title = 'Hello World' 
db.from(Blog).Where(b=>b.Title == "Hello World!").Select(b=>{id:b.Id,title:b.Title})
//select Id as id,Title as title from Blog where Title = 'Hello World' 

//表关联自定义列
db.from(Blog)
.Join(User).ON((b,u)=>b.Creator==u.Id)
.Where<User>(u=>u.Name == "eric johnson")
.Select<Blog,User>((b,u)=>{b,Author:"Joe"})
//select b.Id,b.Title,'Joe' as Author from Blog b
//join User as u on b.Creator = u.Id
//where u.Name = 'eric johnson' 

//子查询
const subQuery = from(User).where(u => u.Name === "eric johnson").select(u => u.Id)
db.from(Blog).where(b => Sql.in(b.UserId, subQuery)
//select * from Blog
//where UserId in (select Id from User",
//                 where Name = 'eric johnson')

const blog = new Blog()
blog.Title = "Hello World!"
//插入全部字段
db.insert(blog)
db.insert({ Title: "Hello World!" } as Blog)
//insert into Blog (UserId,Title,Context) values (1,'Hello World!',null)

//插入部分字段
db.insertFields({ Title: "Hello World!" } as Blog)
//insert into Blog (Title) values ('Hello World!')

//更新全部字段
db.update(blog, b => b.id === 1)
//update Blog set UserId = 1,Title = 'Hello World!',Context = null where Id = 1

//更新部分字段
db.updateFields({ Title: "abc" } as Blog, b => b.Id === 1)
//update Blog set Title = 'abc' where Id = 1

//条件删除
db.delete(Blog, b => b.Id === 1)
//delete from Blog where Id = 1

//复杂条件删除
const subQuery = from(User).where(u => u.Name === "eric johnson").select(u => u.Id)
db.delete(Blog,b => Sql.in(b.UserId, subQuery)
//delete from Blog 
//where UserId in (select Id from User",
//                 where Name = 'eric johnson')

//全表删除
db.deleteAll(Blog)
//delete from Blog