"""
SQL for accessing artists information.

Provides metadata from the release_artist table for performing artists.
For Digital releases, there might be more than one performing artist.
Artist names should be gathered into a comma separated string for display.
"""

GET_AUTHOR_BY_PRODUCT_ID = """
SELECT
  ra.artist_name
FROM
  `release_artist` ra
WHERE
  ra.role = 'performer'
AND
  ra.release_id = :product_id;
"""