i'm not sure if this causes a problem but this shows up in the log on setup (after which everything seems to work ok including dates)
[cafcbd9f-c827-4c71-84cb-34858ec9f720] 2022-11-09T12:01:02-05:00 ERROR metabase.driver.sql-jdbc.execute Failed to set timezone 'UTC' for :netsuite database
java.sql.SQLSyntaxErrorException: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Syntax Error in the SQL statement.[10104]
all making it a model does is nest it in SELECT * FROM () "source" but if orig query has an order by you get "ORDER BY clause is invalid in views, derived tables, and subqueries unless TOP is also specified". I tried changing both the orig and outer queries to "SELECT TOP 10" but it didn't help so would have to dive deeper into suiteql
Oracles implementation uses NUMTODSINTERVAL and NUMTOYMINTERVAL to create relative dates. These methods are not implemented in netsuite's version, go figure.
I've been hacking away on the driver for the last 3 days trying to fix #4 and I've come to realize I am not competent in clojure. I'm happy to provide feedback or testing if needed.
EDIT:
Just wanted to add that month and quarter work correctly.