How to create tables for flask app using peewee orm without double quotes in postgresql

I'm new to peewee orm.

Peewee uses double quotes when creating tables making it unnecessarily difficult to do select statements through psql shell. This goes for django's orm as well.

What I really want is a simple:

select username,password from user;

Instead I'm required to do

select "username", "password" from "user";

I've seen people use sqlalchemy which doesn't require the double quotes. Is there any way for me to turn off the double quotes when creating tables through the orm?

Thanks!

Solution

The double quotes are not part of the actual table/column names. They are simply there so you won't get error messages with names that collide with reserved keywords.

When querying something from the shell you can safely omit them assuming the name does not require quotes because of the reason I just mentioned.