branch: elpa/emacsql commit ad9d1b97156975bf808ecdd8eb65b374b24db1a6 Author: Jonas Bernoulli <jo...@bernoul.li> Commit: Jonas Bernoulli <jo...@bernoul.li>
readme: Use separate section to talk about quoting --- README.md | 18 ++++++++++-------- 1 file changed, 10 insertions(+), 8 deletions(-) diff --git a/README.md b/README.md index 7185c3cfbe..5a6e004126 100644 --- a/README.md +++ b/README.md @@ -146,6 +146,16 @@ For function-like "operators" like `count` and `max` use the `funcall` [:select (funcall max age) :from people] ``` +With `glob` and `like` SQL operators keep in mind that they're +matching the *printed* representations of these values, even if the +value is a string. + +The `||` concatenation operator is unsupported because concatenating +printed representations breaks an important constraint: all values must +remain readable within SQLite. + +## Quoting + Inside expressions, EmacSQL cannot tell the difference between symbol literals and column references. If you're talking about the symbol itself, just quote it as you would in normal Elisp. Note that this @@ -169,14 +179,6 @@ returned as results. Since template parameters include their type they never need to be quoted. -With `glob` and `like` SQL operators keep in mind that they're -matching the *printed* representations of these values, even if the -value is a string. - -The `||` concatenation operator is unsupported because concatenating -printed representations breaks an important constraint: all values must -remain readable within SQLite. - ## Prepared Statements The database is interacted with via prepared SQL s-expression