Mapping Table and Column Names

[jjcroftiv]

Hello, I'm trying to find out if it's possible to change the names of tables and columns used in the database versus the names used in the graphql schema. I'm working with a legacy database that has a lot of terrible names (many composite, assorted, and non-standard abbreviations) that I would prefer not to use in the graphql. So, is there a way to map User in the graphql schema to SOMECRAZYUSERTABLENAME in the database? TIA

[dosco]

you can create synthetic tables in the config and map those to real tables but you cannot do change column names. One solution is to create views in your database that you then query from graphjin.

# create synthetic table 'me' from 'users'
tables:
  - name: me
    table: users