Supported functionality in Babelfish by version - Amazon Aurora

Supported functionality in Babelfish by version

In the following table you can find T-SQL functionality supported by different Babelfish versions. For lists of unsupported functionality, see Unsupported functionality in Babelfish. For information about various Babelfish releases, see the Release Notes for Aurora PostgreSQL.

Functionality or syntax 2.1.0 1.2.1 1.1.0 1.0.0
ALTER ROLE
Connecting with the SSMS object explorer connection dialog
CREATE ROLE
Create unique indexes
Cross–database references SELECT,SELECT..INTO, INSERT, UPDATE, DELETE
Cursor-typed parameters for input parameters only (not output)
Data migration using the bcp client utility
Data migration with the SSMS Import/Export Wizard
Datatypes TIMESTAMP, ROWVERSION (for usage information, see Features with limited implementation
DROP IF EXISTS (for SCHEMA, DATABASE, and USER objects)
DROP ROLE
Identifiers with leading dot character
INSTEAD OF triggers on tables (tables only, not views)
Partial support for the SSMS object explorer
SET BABELFISH_SHOWPLAN_ALL ON (and OFF)
SET BABELFISH_STATISTICS PROFILE ON (OFF)
SET LOCK_TIMEOUT
Triggers with multiple DML actions can reference transition tables
Built-in functions:
CHARINDEX
CHOOSE
COLUMNS_UPDATED
COLUMNPROPERTY (CharMaxLen, AllowsNull only)
CONCAT_WS
CURSOR_STATUS
DATEFROMPARTS
DATETIMEFROMPARTS
FULLTEXTSERVICEPROPERTY
HAS_DBACCESS
HAS_PERMS_BY_NAME
IS_MEMBER
IS_ROLEMEMBER
IS_SRVROLEMEMBER
ISJSON
JSON_QUERY
JSON_VALUE
ORIGINAL_LOGIN
PATINDEX
SCHEMA_NAME
SESSION_USER
SQUARE
STRING_SPLIT
SUSER_SID
SUSER_SNAME
TRIGGER_NESTLEVEL (without arguments only)
UPDATE
INFORMATION_SCHEMA catalogs
COLUMNS
DOMAINS
TABLES
TABLE_CONSTRAINTS
System-defined @@ variables:
@@CURSOR_ROWS
@@DATEFIRST
@@DBTS
@@ERROR
@@ERROR=213
@@FETCH_STATUS
@@IDENTITY
@@LOCK_TIMEOUT
@@LOCK_TIMEOUT
@@MAX_CONNECTIONS
@@MAX_PRECISION
@@MICROSOFTVERSION
@@NESTLEVEL
@@PROCID
@@ROWCOUNT
@@SERVERNAME
@@SERVICENAME
@@SPID
@@TRANCOUNT
@@VERSION (note format difference as described in T-SQL differences in Babelfish.
System stored procedures:
sp_column_privileges
sp_columns
sp_columns_100
sp_columns_managed
sp_cursor
sp_cursor_list
sp_cursorclose
sp_cursorexecute
sp_cursorfetch
sp_cursoropen
sp_cursoroption
sp_cursorprepare
sp_cursorprepexec
sp_cursorunprepare
sp_databases
sp_datatype_info
sp_datatype_info_100
sp_describe_cursor
sp_describe_first_result_set
sp_describe_undeclared_parameters
sp_fkeys
sp_getapplock
sp_helpdb
sp_helprole
sp_helprolemember
sp_helpuser
sp_oledb_ro_usrname
sp_pkeys
sp_pkeys
sp_prepare
sp_releaseapplock
sp_special_columns
sp_sproc_columns
sp_sproc_columns_100
sp_statistics
sp_statistics_100
sp_stored_procedures
sp_table_privileges
sp_tablecollations_100
sp_tables
sp_unprepare
xp_qv
Properties supported on the CONNECTIONPROPERTY system function
auth_scheme
client_net_address
local_net_address
local_tcp_port
net_transport
protocol_type
physical_net_transport
Properties supported on the SERVERPROPERTY function
Babelfish
Collation
CollationID
Edition
EditionID
EngineEdition
IsAdvancedAnalyticsInstalled
IsBigDataCluster
IsFullTextInstalled
IsIntegratedSecurityOnly
IsLocalDB
IsPolyBaseInstalled
IsSingleUser
IsXTPSupported
Japanese_CI_AI
Japanese_CI_AS
Japanese_CS_AS
LicenseType
ProductMajorVersion
ProductMinorVersion
ProductVersion
ServerName
SQL Server views supported by Babelfish
sys.all_columns
sys.all_objects
sys.all_sql_modules
sys.all_views
sys.columns
sys.configurations
sys.data_spaces
sys.database_files
sys.database_mirroring
sys.database_principals
sys.database_role_members
sys.databases
sys.dm_exec_connections
sys.dm_exec_sessions
sys.dm_hadr_database_replica_states
sys.dm_os_host_info
sys.endpoints
sys.indexes
sys.schemas
sys.server_principals
sys.sql_modules
sys.sysconfigures
sys.syscurconfigs
sys.sysprocesses
sys.table_types
sys.tables
sys.xml_schema_collections
syslanguages