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.scm | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'dump.scm') diff --git a/dump.scm b/dump.scm index 784dd15..3ae1dd1 100755 --- a/dump.scm +++ b/dump.scm @@ -126,7 +126,8 @@ association list mapping substrings to their replacements." (syntax->datum ((syntax-rules (field) ((field table column) column) - ((field table column alias) alias)) + ((field table column alias) alias) + ((field table column operation alias) alias)) x))))) x)) @@ -140,7 +141,8 @@ ALIST field-name) forms." (syntax->datum ((syntax-rules (field) ((field table column) column) - ((field table column alias) alias)) + ((field table column alias) alias) + ((field table column operation alias) alias)) x))))) x)) -- cgit v1.2.3