match the keys of a dict in Python to a column in SQL

I am working with a 2x2 SQL table. The first column is an ID, the second is a name. I would like to add a third column to this table from a separate python dict.

This python dict has keys equal to the ID and values equal to that third column I want to add to the SQL table.

How can I match the keys in this dict to the first column in my SQL table, and then add that third column to the table?