Hi!
The error occurred because you forgot to include the correlation name.
To fix this problem, all we need to do is provide a correlation name (also known as a range variable or alias).
Example:
SELECT BulkColumn FROM OPENROWSET (
BULK '/var/opt/mssql/bak/pets.json',
SINGLE_CLOB
) AS MyAlias;