How to avoid mistakes?

Question

Python

Bot on aiogram, you need to remove the column:

@dp.message_handler(commands=['test'])
async def test(message: types.Message):
    conn = sqlite3.connect('db.db')
    cur = conn.cursor()
    number = "md" + str(message.get_args())
    cur.execute("ALTER TABLE users DROP COLUMN '%s'" % number)
    conn.commit()
    await message.reply('готово')

When run in the console, everything works and removes the bars.
But I uploaded it to the hosting and I get an error:

cur.execute("ALTER TABLE users drop column '%s'" % number)
sqlite3.OperationalError: near "drop": syntax error

Answer 1

Up until version 3.35 sqlite could not delete columns at all https://sqlite.org/changes.html#version_3_35_0