Module advanced_objects 

Executor for advanced SQL:1999 objects

This module provides execution functions for advanced SQL objects including:

• SEQUENCE: Auto-incrementing numeric sequences
• TYPE: User-defined types (distinct and structured)
• COLLATION: Character collation definitions
• CHARACTER SET: Character set definitions
• TRANSLATION: Character set translation
• VIEW: Virtual tables based on queries
• ASSERTION: Database-level integrity constraints
• PROCEDURE: Stored procedures with parameter modes
• FUNCTION: User-defined functions
• TRIGGER: Event-driven actions

Note: DOMAIN has a full implementation in the domain_ddl module.

Functions

execute_alter_sequence

Execute ALTER SEQUENCE statement

execute_alter_trigger

Execute ALTER TRIGGER statement

execute_call

Execute CALL statement (SQL:1999 Feature P001)

execute_create_assertion

Execute CREATE ASSERTION statement (SQL:1999 Feature F671/F672)

execute_create_character_set

Execute CREATE CHARACTER SET statement

execute_create_collation

Execute CREATE COLLATION statement

execute_create_function

Execute CREATE FUNCTION statement (SQL:1999 Feature P001)

execute_create_procedure

Execute CREATE PROCEDURE statement (SQL:1999 Feature P001)

execute_create_sequence

Execute CREATE SEQUENCE statement

execute_create_translation

Execute CREATE TRANSLATION statement

execute_create_trigger

Execute CREATE TRIGGER statement

execute_create_type

Execute CREATE TYPE statement (comprehensive implementation)

execute_create_view

Execute CREATE VIEW statement

execute_drop_assertion

Execute DROP ASSERTION statement (SQL:1999 Feature F671/F672)

execute_drop_character_set

Execute DROP CHARACTER SET statement

execute_drop_collation

Execute DROP COLLATION statement

execute_drop_function

Execute DROP FUNCTION statement (SQL:1999 Feature P001)

execute_drop_procedure

Execute DROP PROCEDURE statement (SQL:1999 Feature P001)

execute_drop_sequence

Execute DROP SEQUENCE statement

execute_drop_translation

Execute DROP TRANSLATION statement

execute_drop_trigger

Execute DROP TRIGGER statement

execute_drop_type

Execute DROP TYPE statement (comprehensive implementation with CASCADE/RESTRICT)

execute_drop_view

Execute DROP VIEW statement