Correct SQL query marked as invalid in Plasmic's custom query editor

Issues
1

Hi,
I have written a following query that was tested in Supabase’s SQL editor:

SELECT
  companies.name,
  reviews.user,
  reviews.created_at,
  reviews.review,
  reviews.trust_score
FROM
  reviews
  INNER JOIN companies ON companies.company_id = reviews.company
ORDER BY
  companies.company_id

But when I paste it to the Plasmic’s query editor, the editor returns an error:
Invalid SQL string

What am I missing?

2

Hi, it seems that there is a malfunction with using .user, you should be able to get it to work with:

SELECT
  companies.name,
  reviews."user",
  reviews.created_at,
  reviews.review,
  reviews.trust_score
FROM
  reviews
  INNER JOIN companies ON companies.company_id = reviews.company
ORDER BY
  companies.company_id