piccolo icon indicating copy to clipboard operation
piccolo copied to clipboard
verified publisher icon piccolo-orm

Table names compatibility

Open Forceres opened this issue 1 year ago • 2 comments

Is table with name like "students-teaches" compatible with this ORM? Have such tables and got some errors with joins via join_on

Forceres avatar Jul 13 '24 23:07 Forceres

Names with - in them might cause issues. Unless they're wrapped in quotes i.e. "students-teaches" Postgres will complain. Underscores are preferred.

dantownsend avatar Jul 14 '24 05:07 dantownsend

Names with - in them might cause issues. Unless they're wrapped in quotes i.e. "students-teaches" Postgres will complain. Underscores are preferred.

It shouidn't be a problem. ORM must solve this itself (e.g. NodeJS Typeorm).

Forceres avatar Jul 21 '24 20:07 Forceres