Consider making the __tablename__ of User to be 'users'?

[harrisj]

SQL Alchemy's autogenerated queries are not deterred by this, but it can be hard to query the Postgres directly because user is a reserved word in Postgres. I suggest amending the scaffold by adding a __tablename__ = 'users' to change the name of that table and also show how to override if you need to.