Creates or extends a table with user-defined handlers for query and action operations.
tableas nullable table,
handlersas record) as table
Returns a view of
tablewhere the functions specified in
handlersare used in lieu of the default behavior of an operation when the operation is applied to the view.
Handler functions are optional. If a handler function is not specified for an operation, the default behavior of the operation is applied to
tableinstead (except in the case of
Handler functions must return a value that is semantically equivalent to the result of applying the operation against
table(or the resulting view in the case of
If a handler function raises an error, the default behavior of the operation is applied to the view.
Table.Viewcan be used to implement folding to a data source ? the translation of M queries into source-specific queries (e.g. to create T-SQL statements from M queries).
Please see the published documentation for a more complete description of