Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Adding column aliases #4

Closed
mzas opened this issue Apr 15, 2019 · 1 comment
Closed

Adding column aliases #4

mzas opened this issue Apr 15, 2019 · 1 comment
Assignees
@mzas
Labels
enhancement New feature or request

Comments

@mzas
Copy link
Contributor

mzas commented Apr 15, 2019

J2V outputs SQL without any column aliases. We want to add it.

Build functionality to surface a column alias
e.g. ROOT_ARRAY_ARRAY_FIELDNAME

So the produced SQL:

  • DATA.JSON:"payload":"statuses":"Address":"name"::string AS PAYLOAD_STATUSES_ADDRESS_NAME
  • And in the case of flattened arrays
    DATA.JSON:"payload":"statuses".VALUE:"Address":"name"::string AS PAYLOAD_STATUSES_ADDRESS_NAME

https://github.com/Cimpress-MCP/j2v/tree/column_aliases
@mzas mzas added the enhancement New feature or request label Apr 15, 2019
@mzas mzas self-assigned this Apr 15, 2019
@mzas
Copy link
Contributor Author

mzas commented Apr 16, 2019

Changes implemented.

@mzas mzas closed this as completed Apr 16, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mzas mzas

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@mzas