"Looping" through list in Live Query

Does this example help:

select json_extract(line,'$.timeStamp')as TimeStamp,json_extract(line,'$.serviceName') as ServiceName,json_extract(line,'$.resourceId')as ResourceID from grep where pattern ="{" and path in (select path from file where directory = 'C:\ProgramData\Sophos\Health\Event Store\Trail')

This pulls out a few values from the json files in a directory.

This helps very much and works as is. However, when I try to apply it to my use case I get nothing. This is what I have so far:

select json_extract(line,'$.account_info.email') as state, path from grep where pattern ="{" and path in (select path from file where directory LIKE 'C:\users\%\AppData\Local\Google\Chrome\User Data\Default%%' AND filename IS 'Preferences')

I keep getting:

Anything odd about the Chrome Preferences JSON?

I carried out some testing, it seems there is a limit of 1000 characters per line. That file is one great big long line

Well that's a bummer! I would like to request an increase please! lol

Is this a limit for json_extract only? I am able to use grep in general to pull data...

It seems to be in grep.  If you create a couple of text files:
C:\1000.txt
C:\1001.txt
Add 1000 and 1001 'a' characters on the first line as per the name suggests.
Then run the query:

SELECT * FROM grep WHERE path = C:\1000.txt and pattern ="a"
SELECT * FROM grep WHERE path = C:\1001.txt and pattern ="a"
Only the 1000 query will return a result for me.

It seems to be in grep.  If you create a couple of text files:
C:\1000.txt
C:\1001.txt
Add 1000 and 1001 'a' characters on the first line as per the name suggests.
Then run the query:

SELECT * FROM grep WHERE path = C:\1000.txt and pattern ="a"
SELECT * FROM grep WHERE path = C:\1001.txt and pattern ="a"
Only the 1000 query will return a result for me.

Interesting. The file I am working has a ton of lines but looks like the one with the highest amount of characters is only 470.