Final Class Yiisoft\Db\Sqlite\Builder\InBuilder

                protected function buildCompositeInCondition(
    ?string $operator,
    iterable $columns,
    iterable|Iterator $values,
    array &$params = [],
): string {
    $quotedColumns = [];
    /** @psalm-var string[] $columns */
    foreach ($columns as $i => $column) {
        if ($column instanceof ExpressionInterface) {
            $quotedColumns[$i] = $this->queryBuilder->buildExpression($column);
            continue;
        }
        $quotedColumns[$i] = !str_contains($column, '(')
            ? $this->queryBuilder->getQuoter()->quoteColumnName($column) : $column;
    }
    $vss = [];
    /** @psalm-var string[][] $values */
    foreach ($values as $value) {
        $vs = [];
        foreach ($columns as $i => $column) {
            if ($column instanceof ExpressionInterface) {
                $column = $this->queryBuilder->buildExpression($column);
            }
            if (isset($value[$column])) {
                $phName = $this->queryBuilder->bindParam($value[$column], $params);
                $vs[] = $quotedColumns[$i] . ($operator === 'IN' ? ' = ' : ' != ') . $phName;
            } else {
                $vs[] = $quotedColumns[$i] . ($operator === 'IN' ? ' IS' : ' IS NOT') . ' NULL';
            }
        }
        $vss[] = '(' . implode($operator === 'IN' ? ' AND ' : ' OR ', $vs) . ')';
    }
    return '(' . implode($operator === 'IN' ? ' OR ' : ' AND ', $vss) . ')';
}

            

                protected function buildSubqueryInCondition(
    string $operator,
    iterable|string|Iterator $columns,
    ExpressionInterface $values,
    array &$params = [],
): string {
    if (is_array($columns)) {
        throw new NotSupportedException(__METHOD__ . ' is not supported by SQLite.');
    }
    return parent::buildSubqueryInCondition($operator, $columns, $values, $params);
}