I'm using pycharm for the current project. 
When using the sqlite console under pycharm it shows that it has the version 3.25.1, which means that the sqlite upsert works perfectly. But on python, when I do import sqlite3 it imports the version 3.20.1 of it. 
I don't know why that difference in versions and I want to import the latest version of sqlite in python to be able to work with upserts.
Edit: I'm using Fedora 27 and python 3.7.0
It seems that sqlite 3.24+ requires Fedora 29+.
I just upgraded my fedora to version 29 and I got sqlite 3.24.0
upgrade sqlite to 3.24+ pycharm