Solved: Is there a direct way to get an ID from a hash?

I'm trying to use a local manifest in my apps. Specifically, I want to be able to query my local manifest by hash like one does when using the manifest endpoints. The rows in the manifest have two columns: an ID number and a JSON string for that ID. In many cases, the ID is the same as that row's primary hash; in those cases, I can get the result I want by getting the JSON column from the row whose ID matches the hash I want. However, not ALL rows have ID numbers that match their primary hash (usually in these cases the ID is negative), meaning trying to find these rows using the hash fails. To fix this, I could add a "hash" column to every table, and then loop over every row and extract the primary hash from the JSON to put into that column. However, doing that is extremely computationally expensive, even if I only have to do it once each time a new manifest comes out. As such, is there any formula for converting any hash to its ID, even when the ID doesn't match the hash? If there is one, I could just calculate the ID on the fly without needing to modify the manifest at all.