mt_rand() is discouraged. Use the far less predictable wp_rand() instead.

Simple placeholders should not be quoted in the query string in $wpdb->prepare(). Found: '%s'.

Global constants defined by a theme/plugin should start with the theme/plugin prefix. Found: "KB_IN_BYTES, ..., ..., ...".

Silencing errors is strongly discouraged. Use proper error checking instead. Found: @preg_match( $search_regex,...

// phpcs:ignore WordPress.PHP.NoSilencedErrors.Discouraged -- Unsure why this is needed, leaving in for now.

Use placeholders and $wpdb->prepare(); found interpolated variable ...

// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Escaped through esc_sql_ident/esc_like.

// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Asserted to be a valid table name through wp_get_table_names.

Object property "$Xxx" is not in valid snake_case format, try "$xxx"

// phpcs:disable WordPress.NamingConventions.ValidVariableName.UsedPropertyNotSnakeCase -- Property names come from database.
if ( 'PRI' === $col->Key ) {
	$primary_keys[] = $col->Field;
}
if ( self::is_text_col( $col->Type ) ) {
	$text_columns[] = $col->Field;
}
$all_columns[] = $col->Field;
// phpcs:enable