Simple SQLite3 console. You can use DML (SELECT, INSERT, UPDATE, DELETE).

sqlite3_console.py

from cmd import Cmd
from sys import argv
import sqlite3
import traceback

class SqliteCmd(Cmd):
  dml = ['SELECT', 'INSERT', 'UPDATE', 'DELETE']
  def __init__(self, dbfile):
    super().__init__()
    self.conn = sqlite3.connect(dbfile)
  def onecmd(self, arg):
    flg = False
    for i in self.dml:
      if i in arg.upper():
        flg = True
    if not flg:
      super().onecmd(arg)
    else:
      cur = self.conn.cursor()
      try:
        cur.execute(arg)
        if 'SELECT' in arg.upper():
          for row in cur:
            print(row)
        else:
          self.conn.commit()
      except:
        traceback.print_exc()
      finally:
        cur.close
  def do_quit(self, arg):
    self.conn.close()
    quit()
    return True

cmd = SqliteCmd(argv[1])
cmd.prompt = '> '
cmd.cmdloop('This is simple SQLite console.')