Mostly or maybe entirely due to `asMappedResults()...
# suitescript
e
Mostly or maybe entirely due to
asMappedResults()
🙂
d
I can't agree more. I can think of tons of code I can now get rid of. The code converting search results into usable objects
s
NFT has had that in a single method,
nsSearchResult2obj()
for years.
What irks me is the query creation syntax in N/query
I plan to dig into it more when SuiteQL is more fully baked
@erictgrubaugh are you crafting queries with SuiteQL yet?
e
I am not
my SQL-fu is very bad
No part of writing SQL excites me. I'll very likely stick to the API instead.
but I definitely understand why it's going to be a useful feature
s
I agree with you about SQL overall - I've never liked having to swap languages to do data vs other logic, and especially not a fan of just unchecked strings that SQL ends up being.
In other words, I rather dislike SQL, but I do appreciate it's concise power. I think the killer feature would be if SuiteQL allows for arbitrary joins (like 'real' SQL) then I'll have to ignore my distaste. SQL has been around basically my entire career and I've never been a fan of programming it (compared to strongly typed languages especially)
👍 1