This is a method for getting objects from hashes specifically using sqlite3 for the Destiny 2 API

sqlite3 for Destiny 2 API

import sqlite3
con = sqlite3.connect('Manifest.content')
cur = con.cursor()

def getItemName(itemHash):
    #create id from hash
    if (itemHash & (1 << (32 - 1))) != 0:
        itemHash = itemHash - (1 << 32)
    cur.execute("SELECT json FROM DestinyInventoryItemDefinition WHERE id=?", (itemHash,))
    #print(cur.fetchall())
    item = json.dumps(cur.fetchall()[0])
    item = json.loads(json.loads(item)[0])
    print(itemHash,item)
    return item.get('displayProperties', {}).get('name', 'NA')