Convert NewPipe playlists from SQLite to JSON

pipe.py

import sqlite3
import json

if __name__ == '__main__':
    with sqlite3.connect('newpipe.db') as conn:
        c = conn.cursor()

        playlists = { id:{'name':name, 'tracks':[]} for id, name, _ in \
                      c.execute('select * from playlists') }

        stream_to_playlist = { stream_id:playlist_id for playlist_id, stream_id, _ in \
                               c.execute('select * from playlist_stream_join') }

        streams = { id:(title, url) for id, _, url, title, _, _, _, _, _, _, _, _ in \
                    c.execute('select * from streams') }

        for stream_id in streams:
            try:
                playlist_id = stream_to_playlist[stream_id]
            except KeyError:
                continue

            playlist = playlists[playlist_id]

            title, url = streams[stream_id]
            playlist['tracks'].append({'title':title, 'url':url})

        with open('playlists.json', 'w') as f:
            f.write(json.dumps({ playlists[id]['name']:playlists[id]['tracks'] \
                                 for id in playlists }))