[jira] [Commented] (METAMODEL-193) Query parser support for "CAST AS " expression

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/METAMODEL-193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14947309#comment-14947309 ] 

ASF GitHub Bot commented on METAMODEL-193:
------------------------------------------

Github user kaspersorensen commented on the pull request:

    https://github.com/apache/metamodel/pull/55#issuecomment-146283048
  
    Reported your idea in METAMODEL-193 - https://issues.apache.org/jira/browse/METAMODEL-193


> Query parser support for "CAST <field> AS <type>" expression
> ------------------------------------------------------------
>
>                 Key: METAMODEL-193
>                 URL: https://issues.apache.org/jira/browse/METAMODEL-193
>             Project: Apache MetaModel
>          Issue Type: Improvement
>            Reporter: Kasper Sørensen
>
> As a natural addition to the work with datatype-converter functions of METAMODEL-192, we could also provide some syntax support for a pretty normal way of converting/casting data types in SQL:
> {code}
> SELECT CAST id AS string FROM table
> {code}
> We have converter functions for strings, numbers, dates and booleans. But they currently require you to use a function style syntax like:
> {code}
> SELECT TO_STRING(id) FROM table
> {code}
> Supporting both syntax styles would be nice for SQL users.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)