Laravel Framework Query : "INSERT OR ignore ..." Syntax Error

[AtibaLee]

When using the LoginRequest RateLimiter that caches a failed login attempt Laravel attempts to run a query that starts with "INSERT OR ignore.. " . This syntax is not supported by snowflake.

This codeflow is part of the Laravel Framework. and I am unaware of how to change the query to use an alternative syntax.

Any alternative to the INSERT IGNORE syntax would be to use an insert that uses a select statement that has a where exists clause.

Example Query:

insert or ignore into "cache" ("key", "value", "expiration") values (?, ?, ?)

This exception is being thrown at

App\ Http\ Requests\ Auth\ LoginRequest: 45 authenticate

` public function authenticate(): void
{

    $this->ensureIsNotRateLimited();

    if (! Auth::attempt($this->only('email', 'password'), $this->boolean('remember'))) {
        RateLimiter::hit($this->throttleKey());

        throw ValidationException::withMessages([
            'email' => trans('auth.failed'),
        ]);
    }
    RateLimiter::clear($this->throttleKey());
}`

Laravel Version : 11.5.0
PHP Version: 8.2.15

[yoramdelangen]

I think this was not implemented yet.. and Snowflake does not have a direct way of doing this. The only thing close is INSERT OVERWRITE.