"""Content metadata queries."""

RELEASE_ARTIST = """
SELECT
    ra.release_artist_id AS artist_id,
    ra.artist_name AS artist_name,
    LOWER(ra.role) AS artist_role
FROM release_artist AS ra
WHERE ra.release_id = %(product_id)s
  AND ra.role <> 'feature_to_primary';
"""