Using SUBSTR() function

I am using ASP .Net Core 6 and Couchbase Mobile Lite 3.0.2
I have a query like below using SUBSTR and whenrunning I am getting the error like “N1QL syntax error near character 14.'” Does Couchbase Lite supports SUBSTR ?

var q = “SELECT SUBSTR(TallyNumber, 0, 2) as Tally FROM MakeUpJobLocalCouchbaseLite WHERE docType=‘Tally’”;
var query = db.CreateQuery(q);

No, Couchbase Lite does not support this function. You can see what is supported here

@borrrden Thank you so much for the update.