Multi-Word Strings get truncated on output

[zardoz03]

Multi-Word Strings get truncated on output

[tarsius]

That is a consequence of the design decision commented on in this FAQ entry: https://github.com/magit/emacsql#why-are-all-values-stored-as-strings.

Since the metadata you are requesting here was not explicitly stored by EmacSQL itself, it wasn't printed, so when EmacSQL uses read on what it got from SQLite, then this happens: (read "CREATE TABLE EXPENSE_TYPES ...") => CREATE. EmacSQL cannot easily know that in that one case, it should not do that.

For the backend that uses built-in sqlite support, this happens in emacsql-send-message, for most other backends it happens in emacsql-parse.

I recommend, that for this one query, you fall back to a direct call to sqlite-select. Of course if you do not exclusively use the builtin backend, this will be more complicated.

[zardoz03]

I knew it had to be a consequence of it mainly storing emacs pretty-printable values, but forgot about how READ truncates data. theres probably some way to wrap it as a "(list ...)" before passing it to READ but i fear that overcomplicates things further than trying to re-architect based on storing elisp values as a proper serialized object and supporting normal SQL data types.