A way to specify the enclosing character

[simonaubertbd]

Hello,

Reading the documentation and in the examples, the enclosing character is always "

https://pypika.readthedocs.io/en/latest/2_tutorial.html

SELECT "history".* FROM "history" JOIN "customers" ON "history"."customer_id"="customers"."id" WHERE "customers"."id"=5

However, it may differ in many databases such as Apache Hive where it 's a backtick.

Therefore, I would like a way to specify this enclosing character.

Best regards,

Simon

[maen-allaga]

@simonaubertbd (I'm not a maintainer, so take my answer with a grain of salt please).
I believe what you're asking for is a new Dialect

[simonaubertbd]

@maen-allaga Hello and thanks for your answer. Not exactly. For me, it should work that way :
-dedicated dialectS. Enclosing character is well specified.
-generic dialect (some kind of "default" one). Enclosing character is by default the double quote but the user has the ability to specify another one.

Moreoever, I'm not sure that now, the enclosing character is specified (but I may have missed that in the code).

Best regards,

Simon