How to make a negative offset in sqlite?

Question

Python

Hello. To be clear, when you specify the OFFSET parameter in the query, it only works with positive numbers (if OFFSET is negative, then sqlite seems to ignore it altogether). Here is my crutch solution:

import sqlite3

def get_data(id, date, limit=1, offset=0):
    con = sqlite3.connect('db.db')
    cur = con.cursor()
    data = []
    if offset < 0:
        cur.execute('SELECT * FROM db WHERE id == ? AND date >= '
                    '(SELECT date FROM db WHERE date <= ? '
                    'ORDER BY _rowid_ DESC LIMIT 1 OFFSET ?) LIMIT ?',
                    (id, date, -offset, limit))
    else:
        cur.execute('SELECT * FROM db WHERE id == ? AND date >= ? '
                    'LIMIT ? OFFSET ?',
                    (id, date, limit, offset))
    for row in cur.fetchall():
        data.append({'date': datetime.date.fromisoformat(row[1]),
                       'name': row[2], 'address': row[3]})
    return data

Answer 1

In SQL, according to the standard, OFFSET must always be >=0, so there is no way to force it to be negative.
Your crutch option is quite acceptable.
But I would once again think whether this feature is needed at all.

Answer 2

I don't understand anything :) But what if we sort in the reverse order and apply the usual OFFSET? :)