Are there plans to incorporate AI (eg CoPilot) for code completion? or is this left to 3rd parties?
I would like to say: “Ok Larry, validate that these selected columns are US dates”
Engine should then look for the most promising Domain for “US date”, using current connection, and find (because of the Annotation):
create domain date_us
check ( to_date( value default null on conversion error, 'mm/dd/yyyy' ) is not null )
annotations ( description 'US Date' );
Then adds columns to the end of the select
clause using a template similar to:
,domain_check( date_us /* found domain*/, selected_column ) as is_selected_column_valid