from pgcrud import e, f, q

q.SELECT((e.department.id, e.department.name, f.avg(e.employee.salary).AS('avg_salary'))).\
FROM(e.employee).\
JOIN(e.deparment.ON(e.employee.department_id == e.departement.id)).\
GROUP_BY(e.employee.department_id)
# SELECT "department"."id", "department"."name", avg("employee"."salary") AS "avg_salary" FROM "employee" JOIN "deparment" ON "employee"."department_id" = "departement"."id" GROUP BY "employee"."department_id"

q.INSERT_INTO(e.employee[e.name, e.salary, e.department_id]).\
VALUES(('John Doe', 1000, 1), {'name': 'Jane Doe', 'salary': 2000, 'department_id': 2}).\
RETURNING(e.id)
# INSERT INTO "employee" ("name", "salary", "department_id") VALUES ('John Doe', 1000, 1), ('Jane Doe', 2000, 2) RETURNING "id"

q.UPDATE(e.employee).\
SET((e.salary, e.department_id), (3000, 3)).\
WHERE(e.id == 1)
# UPDATE "employee" SET ("salary", "department_id") = (3000, 3) WHERE "id" = 1

q.DELETE_FROM(e.employee).\
WHERE(e.salary > 10000).\
RETURNING(e.id)
# DELETE FROM "employee" WHERE "salary" > 10000 RETURNING "id"

           _~~+-~_
       () /  ← o  \ (/
         '_   ⩌   _'
         / '--.--' )

...act by ferris-actor v0.2.4 (built on 23.0303.201916)

[皱眉]每周新闻资讯 怎么能错过 
看看有什么新东西 
当有新的发现时：
    what f**k 还能这样玩？ 还有这东西？
    每周开彩蛋[吃瓜]

askdama@googlegroups.com

全职嗯哼: 大妈的多重宇宙 - https://www.youtube.com/@Chaos42DAMA
私自嗯哼: ZoomQuiet (订阅号: ZoomQuiet42)

as 创始组织者:
    CPyUG (mailling-list: python-cn@googlegroups.com)
    PyChina (订阅号: PyChinaOrg)
    本地社区: 
        GDG珠海 (订阅号: GDG-ZhuHai)
        AIGC珠海