Korma -在子选择上加入，但我如何指定别名？

Question

我想为这个查询中的子选择指定一个别名：

(->
  (korma/select* table_a)
  (korma/join
   (korma/subselect table_b
                    (korma/fields :id (korma/raw "COUNT(*) AS count"))
                    (korma/group :id))
   (= :id :id)))

这就是我想要创建的sql：

SELECT * FROM table_a LEFT JOIN (SELECT id, COUNT(*) AS count FROM table_b GROUP BY id) AS b b.id = id;

但是，目前sql korma只生成：

SELECT * FROM table_a LEFT JOIN (SELECT id, COUNT(*) AS count FROM table_b GROUP BY id) id = id;

Answer 1

我需要将子选择定义为一个单独的实体，请参见下面的内容：

(korma/defentity sub-select
             (korma/table (korma/subselect table_b
                                           (korma/fields :id(korma/raw "COUNT(*) AS count"))
                                           (korma/group :id)) :b))

(->
  (korma/select* table_a)
  (korma/join sub-select (= :b.id :id)))

它生成以下查询：

SELECT * FROM table_a LEFT JOIN (SELECT id, COUNT(*) AS count FROM table_b GROUP BY id) a.id = id;