Should already be able to:
https://redash.io/help/user-guide/integrations-and-api/api
For example: https://aftershock.lemmy.management/api/queries/4/results
The API key for public users is the same as the dashboard slug: oT7pdcoeHWccpvZCNmTpJKoGZND8ZdRO3wDWpMug