https://flask-ckeditor.readthedocs.io/en/latest/
I am 100% sure the query is correct because I looked at dbeaver and the text is https://imgur.com/a/fDBobqZ , though there is a weird character at the end.
Here is what I tried.
book_db = db.session.execute(db.insert(Book).values(text='<p>A</p>').returning(Book))
The above code takes place in a custom flask wtf validator.
So normally <p>A</p> would replaced by the input from the form.