Selective recommendation and deployment of extensions in low-code approach

A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for one or more of adding extensions and providing default values to extensions in database systems, the operations comprising:

• querying metadata of data objects in a set of data objects to determine presence of one or more of a generic text field and an attachment field within a set of tables stored in the database system, each data object in the set of data objects corresponding to a respective table in the set of tables;
• defining a sub-set of data objects, each data object in the sub-set of data objects comprising one or more of a generic text field and an attachment field within the respective table;
• and
• for each data object in the sub-set of data objects:
• processing historical data of the data object using at least one regular expression to identify a set of data types, the historical data stored within a field of the respective table stored in the database system,
• in response to determining that a frequency of data of a first data type included in the generic text field exceeds a threshold frequency, displaying to a user a recommendation for a first extension corresponding to a first data type in the set of data types, the first extension comprising adding a column to the respective table, the column representing a field for the first data type that is absent from the respective table, and
• receiving user input from the user, the user input indicating acceptance of the recommendation for the first extension and, in response, automatically:
• providing extension code that is executable to add a field extension to the respective table and to modify a user interface (UI) of an application for input of values corresponding to the first data type, and
• executing the extension code to deploy the extension and to modify the UI.

A system, comprising:

• a computing device;
• and
• a computer-readable storage device coupled to the computing device and having instructions stored thereon which, when executed by the computing device, cause the computing device to perform operations for one or more of adding extensions and providing default values to extensions in database systems, the operations comprising:
• querying metadata of data objects in a set of data objects to determine presence of one or more of a generic text field and an attachment field within a set of tables stored in the database system, each data object in the set of data objects corresponding to a respective table in the set of tables;
• defining a sub-set of data objects, each data object in the sub-set of data objects comprising one or more of a generic text field and an attachment field within the respective table;
• and
• for each data object in the sub-set of data objects:
• processing historical data of the data object using at least one regular expression to identify a set of data types, the historical data stored within a field of the respective table stored in the database system,
• in response to determining that a frequency of data of a first data type included in the generic text field exceeds a threshold frequency, displaying to a user a recommendation for a first extension corresponding to a first data type in the set of data types, the first extension comprising adding a column to the respective table, the column representing a field for the first data type that is absent from the respective table, and
• receiving user input from the user, the user input indicating acceptance of the recommendation for the first extension and, in response, automatically:
• providing extension code that is executable to add a field extension to the respective table and to modify a user interface (UI) of an application for input of values corresponding to the first data type, and
• executing the extension code to deploy the extension and to modify the UI.