Generate sql error

[yqz945]

from pypika import Query, Table

customers = Table('batch')
q_str =str(Query.from_(customers).select(customers.id))
print(q_str)

SELECT "id" FROM "batch"

Because the Double quotation marks " exists,

ProgrammingError: (pymysql.err.ProgrammingError) (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"batch"' at line 1')
[SQL: SELECT "id" FROM "batch"]

How does is works?

[JasonDeRice]

you can try q_str.get_sql(quote_char=None), that will remove the quotation around fields.