您可以在SQL引用特定数据集中传递参数吗？

Question

我有一个数据库，在数据库中，我想引用特定的数据集。当用户查询时，我希望它仅返回与用户相关的数据，而不是返回与他们无关的类似数据集。我想使用诸如关键字参数之类的内容，并且我知道SQL具有其中子句，但它是有限的，并且不能使一个人返回一组特定的数据。

self._headers = {'User-Agent': 'Mozilla/5.0 (X11; Linux i686; rv:78.0) Gecko/20100101 Firefox/78.0', 'Accept-Language': 'en-US,en;q=0.5'}

上面的示例引用了一个特定的实例，这就是我在数据库中要做的。

from cmath import e
from http.client import OK
from logging import exception
from socket import if_nameindex
import psycopg
import datetime
from config import *


class profiles:

    def commercial_profile(self):
        conn = None

        try:
            with psycopg.connect(
                dbname = dbname,
                user = user,
                password = password,
                host = host,
                port = port
            ) as conn:

                with conn.cursor() as cur:

                    total_streaming_plays = '''WITH temp AS (
                    SELECT artist, plays FROM machine_spotify
                    UNION ALL
                    (SELECT artist, plays FROM machine_tidal)
                    UNION ALL
                    (SELECT artist, plays FROM machine_soundcloud)
                    UNION ALL
                    (SELECT artist, plays FROM machine_youtube)
                    UNION ALL
                    (SELECT artist, plays FROM machine_youtube_music)
                    ) SELECT SUM(plays) AS total_plays 
                    FROM temp;'''

                    cur.execute(total_streaming_plays) 
                    for records in cur:
                        print(records[0] * 2)  

                conn.commit()

        except Exception as e:
            print(e)

        finally:
            if conn is not None:
                conn.close()

在我的上述查询中，它是选择艺术家，从Machine_spotify中播放，我想让选择Artist = {username}，从Machine_spotify在数据库中引用用户名的数据。 <代码> 条款将有效，但这将是限制的。