Issue
When importing any table that contains NULL values from a SQL database, JMP will return values where there should be missing values. The NULLs should be marked as missing values in the imported table.
On Windows, the issue only occurs when the Block Fetch preference is enabled. On MacOS this issue occurs despite the status of Block Fetch.
Preferences(ODBC Disable Block Fetch(1));
The 0s in this table should be missing values.

Table as it returns using SQL Server query editor.

Workaround
On Windows do not use block fetch.
On MacOS, there is no workaround.