Hi @CarlosArizmendi-1254,
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.
Please refer to MS document Convert SQL Server data to JSON or export JSON or the blog to get more details.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".