We can export data in SQL to JSON text, but not .JSONL File. JSON functions is supported from SQL 2016 to later. Format SQL Server data or the results of SQL queries as JSON by adding the FOR JSON clause to a SELECT statement.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".