Bug: issue with babel and sqlite [9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)]

[rrandresf]

Remember to cover the basics, that is, what you expected to happen and
what in fact did happen.  You don't know how to make a good report?  See

     https://orgmode.org/manual/Feedback.html#Feedback

Your bug report will be posted to the Org mailing list.
------------------------------------------------------------------------
Hi. I am testing the pretest. And I have try the snippet below on emacs -Q

1. M-x find-file ~/borrame.org
2. cp content below to borrame.org buffer:
--8<---------------cut here---------------start------------->8---
* on a terminal on your HOME evalute (C-c C-c) the blocks below sequentially 
from top to bottom
#+BEGIN_SRC emacs-lisp
(when (fboundp 'org-babel-do-load-languages)
    (org-babel-do-load-languages
     (quote org-babel-load-languages)
     (quote ((emacs-lisp . t)
             (sqlite . t)
             )))
    )
(shell-command-to-string "sqlite3 ~/my_timelines.sqlite3 'CREATE TABLE IF NOT 
EXISTS time_lines (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title 
varchar(255));'")
#+END_SRC

** this subtree works as expected
#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
INSERT INTO time_lines values(1, 'simple tiny note' );
#+END_SRC

#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
select * from time_lines;
#+END_SRC

** this subtree create three colums
#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
INSERT INTO time_lines values(2, 'an issue|problem with table rendering' );
#+END_SRC

#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
-- note the three colums on the table
select * from time_lines;
#+END_SRC

** this subtree generates an errro
#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
INSERT INTO time_lines values(3, '{
"id": 0
"value": 1
}');
#+END_SRC

#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
-- this generates an "org-babel-read: End of file during parsing" because of 
the inserted json
select * from time_lines;
#+END_SRC
--8<---------------cut here---------------end--------------->8---

Best

Emacs  : GNU Emacs 27.0.91 (build 1, armv7l-unknown-linux-gnueabihf, X toolkit, 
Xaw3d scroll bars)
Package: Org mode version 9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)

current state:
==============
(setq
 org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-show-empty-lines
                  org-optimize-window-after-visibility-change)
 org-archive-hook '(org-attach-archive-delete-maybe)
 org-agenda-before-write-hook '(org-agenda-add-entry-text)
 org-link-elisp-confirm-function 'yes-or-no-p
 org-babel-pre-tangle-hook '(save-buffer)
 org-occur-hook '(org-first-headline-recenter)
 org-mode-hook '(#[0 "\300\301\302\303\304$\207"
                   [add-hook change-major-mode-hook org-show-all append local]
                   5]
                 #[0 "\300\301\302\303\304$\207"
                   [add-hook change-major-mode-hook org-babel-show-result-all
                    append local]
                   5]
                 org-babel-result-hide-spec org-babel-hide-all-hashes)
 org-speed-command-hook '(org-speed-command-activate
                          org-babel-speed-command-activate)
 org-metaup-hook '(org-babel-load-in-session-maybe)
 org-bibtex-headline-format-function #[257 "\300\236A\207" [:title] 3 "\n\n(fn 
ENTRY)"]
 org-confirm-shell-link-function 'yes-or-no-p
 org-clock-out-hook '(org-clock-remove-empty-clock-drawer)
 org-link-shell-confirm-function 'yes-or-no-p
 org-tab-first-hook '(org-babel-hide-result-toggle-maybe
                      org-babel-header-arg-expand)
 org-link-parameters '(("attachment" :follow org-attach-open-link :export
                        org-attach-export-link :complete
                        org-attach-complete-link)
                       ("id" :follow org-id-open)
                       ("eww" :follow eww :store org-eww-store-link)
                       ("rmail" :follow org-rmail-open :store
                        org-rmail-store-link)
                       ("mhe" :follow org-mhe-open :store org-mhe-store-link)
                       ("irc" :follow org-irc-visit :store org-irc-store-link
                        :export org-irc-export)
                       ("info" :follow org-info-open :export org-info-export
                        :store org-info-store-link)
                       ("gnus" :follow org-gnus-open :store
                        org-gnus-store-link)
                       ("docview" :follow org-docview-open :export
                        org-docview-export :store org-docview-store-link)
                       ("bibtex" :follow org-bibtex-open :store
                        org-bibtex-store-link)
                       ("bbdb" :follow org-bbdb-open :export org-bbdb-export
                        :complete org-bbdb-complete-link :store
                        org-bbdb-store-link)
                       ("w3m" :store org-w3m-store-link) ("file+sys")
                       ("file+emacs") ("shell" :follow org-link--open-shell)
                       ("news" :follow
                        #[257 "\301\300\302Q!\207" ["news" browse-url ":"] 5
                          "\n\n(fn URL)"]
                        )
                       ("mailto" :follow
                        #[257 "\301\300\302Q!\207" ["mailto" browse-url ":"]
                          5 "\n\n(fn URL)"]
                        )
                       ("https" :follow
                        #[257 "\301\300\302Q!\207" ["https" browse-url ":"]
                          5 "\n\n(fn URL)"]
                        )
                       ("http" :follow
                        #[257 "\301\300\302Q!\207" ["http" browse-url ":"] 5
                          "\n\n(fn URL)"]
                        )
                       ("ftp" :follow
                        #[257 "\301\300\302Q!\207" ["ftp" browse-url ":"] 5
                          "\n\n(fn URL)"]
                        )
                       ("help" :follow org-link--open-help)
                       ("file" :complete org-link-complete-file)
                       ("elisp" :follow org-link--open-elisp)
                       ("doi" :follow org-link--open-doi))
 org-src-mode-hook '(org-src-babel-configure-edit-buffer
                     org-src-mode-configure-edit-buffer)
 org-confirm-elisp-link-function 'yes-or-no-p
 org-metadown-hook '(org-babel-pop-to-session-maybe)
 )