Python3: load multiple SQLite rows into one NamedTuple object

sqlite_magic.py

import sqlite3
from typing import namedtuple

class Environment(NamedTuple):
    SLACK_CLIENT_ID: str
    SLACK_CLIENT_SECRET: str
    SECRET_KEY: str
        
conn = sqlite3.connect('config.db')
conn.row_factory = sqlite3.Row

cur = conn.execute('SELECT * FROM environment')
res = cur.fetchall()
env = Environment(**{r['name']: r['value'] for r in res})
# env == Environment(SLACK_CLIENT_ID='1234.5678', SLACK_CLIENT_SECRET='akshdfjhafhadf', SECRET_KEY='verysecret')