Reverse transform of column names when inserting or updating

[davojan]

Transforming column names in both ways would greatly improved ergonomics of the library. Consider this example:

const sql = postgres({
  transform: {
    column: postgres.toCamel,
  },
}) 
const entity = {
  appliedAt: new Date,  // db column name is "applied_at"
}
// error: column "appliedat" of relation "some_table" does not exist
sql`INSERT INTO some_table ${sql(entity)}`

Transform option should work both ways, I think. May be configured like this:

{
  transform: {
    column: {
      fromDb: postgres.toCamel,
      toDb: postgres.toSnake,
    },
  },
}

[porsager]

Hi @davojan ..

Yes I have considered an option for that.. Good to track in this issue - thanks ;)

[porsager]

I like the non breaking way you suggested of supplying an object with { to, from }

[michael-land]

It would be useful!

[michael-land]

Should we also transform column name for sql(obj, ...columns_names) ?

user can use sql(customer, 'firstName') instead of sql(customer, 'first_name')

it also useful for typescript I guess, we can restrict column name to keyof T

[iby]

@porsager Hey! Need this one badly. Has anyone worked on this? Are you open towards the PR? P.S. Also love the idea with { to, from }.

[basaran]

this could be extremely useful.

[porsager]

@iby and @basaran Would you mind trying out how #212 works for you?

For eg. camel casing use:

const sql = postgres({
  transform: {
    column: { to: postgres.fromCamel, from: postgres.toCamel }
  }
})

[basaran]

Hello,

Thank you, I think it's fine:

CREATE TABLE IF NOT EXISTS public."camelTable"
(
    snake_to_camel text COLLATE pg_catalog."default"
)

async function dooo() {
    const importantInformation = {
        snakeToCamel: "aaaa",
    };

    const importantColumns = ["snakeToCamel"];

    const a_insert = await sql`
      INSERT INTO "camelTable" ${sql(importantInformation)}
    `;

    const b_select = await sql`
      SELECT ${sql(importantColumns)} FROM "camelTable" 
    `;

    console.log(a_insert);
    console.log(b_select);
}

INSERT INTO "camelTable" ("snake_to_camel") values ($1)
[{"type":0,"value":"aaaa","raw":"aaaa"}]
SELECT "snake_to_camel" FROM "camelTable"
[
  count: 1,
  command: 'INSERT',
  state: { status: 'I', pid: 1634864, secret: 1829386482 }
]
[
  { snakeToCamel: 'aaaa' },
  { snakeToCamel: 'aaaa' },
  columns: [ { name: 'snakeToCamel', parser: undefined, type: 25 } ],
]

[porsager]

Fixed with #212