maybe_add_column()

maybe_add_column( string $table_name, string $column_name, string $create_ddl ): bool

function maybe_add_column( $table_name, $column_name, $create_ddl ) {
	global $wpdb;

	// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Cannot be prepared. Fetches columns for table names.
	foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
		if ( $column === $column_name ) {
			return true;
		}
	}

	// Didn't find it, so try to create it.
	// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- No applicable variables for this query.
	$wpdb->query( $create_ddl );

	// We cannot directly tell whether this succeeded!
	// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Cannot be prepared. Fetches columns for table names.
	foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
		if ( $column === $column_name ) {
			return true;
		}
	}

	return false;
}