From 77ef1e2f4733ff64cddf3b8cdf955cf4a21691f4 Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Wed, 8 Mar 2023 18:15:41 +0300 Subject: Add ability to have operations such as GROUP_CONCAT in SELECT clause This change enables having: "... GROUP_CONCAT(GeneRIF_BASIC.PubMedId) AS alias ..." as part of the query. * dump.scm (field->key, field->assoc-ref): Add new syntax-rule. * dump/sql.scm (select-query): Ditto. Signed-off-by: Munyoki Kilyungi --- dump/sql.scm | 2 ++ 1 file changed, 2 insertions(+) (limited to 'dump/sql.scm') diff --git a/dump/sql.scm b/dump/sql.scm index 74f3139..54371a2 100644 --- a/dump/sql.scm +++ b/dump/sql.scm @@ -33,6 +33,8 @@ (format #f "~a.~a" table column)) ((table column alias) (format #f "~a.~a AS ~a" table column alias)) + ((table column operation alias) + (format #f "~a(~a.~a) AS ~a" operation table column alias)) (field-spec (error "Invalid field specification" field-spec))) (syntax->datum #'fields)) -- cgit v1.2.3