Internal supports SQL Server 2019, and Azure SQL.
When you connect SQL Server to Internal, we'll generate the following for you automatically:
In some cases, you may want to create a view that combines data from various tables or elevates nested JSON fields to top-level attributes. To accomplish this, create a custom SQL Resource (a.k.a. SQL Query). To enable custom operations that write directly to your database (e.g. bulk actions), create a custom Function.
While Internal enables filtering and sorting on all columns (except box, circle, line, lseg, json, path, point, polygon, txid_snapshot, xml), we recommend indexing columns on large tables to improve performance. Supported operators include '=, !=, <, <=",">, >=, and IN for all data types. ILIKE is supported for char, varchar, nchar, and nvarchar only.</,>