I'm submitting the annual BFN questionnaire for my...
# suiteqlb
burkybang
01/27/2022, 4:13 PMI'm submitting the annual BFN questionnaire for my SuiteApp, and there's a new question regarding SuiteQL.
If your SuiteApp uses SuiteQL, are any of your queries use both SQL-92 and Oracle SQL?(Yes, the question has that weird wording) How can I tell if my SuiteQL is using both SQL-92 and Oracle SQL or not? I wasn't aware there's a difference.
a
Alan Fitch
01/27/2022, 5:15 PMI would venture to guess that the question is
If your SuiteApp uses SuiteQL, are any of your queries allowed to use both SQL-92 and Oracle SQL?
I'm pretty sure the answer is no.
m
Marc Reicher
01/27/2022, 7:10 PMI had this same exact question!
Marc Reicher
01/27/2022, 7:11 PMBtw, I answered Yes, and then was told my answer was unacceptable. I was told our queries needed to use either Oracle SQL or SQL-92
😂 1
Marc Reicher
01/27/2022, 7:12 PMI sent a follow up to NetSuite as the question has confused our engineering team a bit. Sounds like it's not super straightforward to understand the sql statements unique to each language
a
Alan Fitch
01/27/2022, 7:13 PMYup. Although I think it's only in a single query i.e a query must not use features from both SQL-92 and Oracle. A SuiteApp can have two separate queries in two separate languages.
m
Marc Reicher
01/27/2022, 7:13 PMright. Fwiw, we thought we might have a query that uses features of each language, but it still does work on 2022.1
a
Alan Fitch
01/27/2022, 7:18 PMKnowing Oracle my guess is the code looks like this:
Copy code
try { return evaluatewithsql92(sql)}
catch { return evaluatewithoracle(sql)}
catch(e) { return "oops"}😂 2
Alan Fitch
01/27/2022, 7:24 PM@burkybang CTEs and window functions come to mind as examples of sql paradigms not supported by SQL-92.
Finding an example of sql not supported by Oracle but supported by SQL-92 is a challenge.
CC: @tdietrich
☝️ 1
2 Views