Error with ::vector(1536) – pgvector + PostgreSQL

[ahmadmayahi]

Telescope Version

5.10.0

Laravel Version

12.20.0

PHP Version

8.4.10

Database Driver & Version

pgsql 17

Description

I’m running into a parsing error when using a query like this in Telescope:

Parse error: Unexpected "::vector(1"
This likely happens because you're using the default "sql" dialect.

This is the line that seems to break it:

?::vector(1536)

It’s valid PostgreSQL syntax when using the pgvector extension, works fine in the database itself. But whatever is parsing the query (probably for display or formatting in the frontend) doesn’t seem to recognize the ::vector cast and throws an error.

My Query (Truncated):

WITH vectorchord_candidates AS (
    SELECT id, chunk, embedding, agent_file_id,
           {$distanceOperator}
    FROM documents
    WHERE agent_id = ?
    ORDER BY embedding <-> ?::vector(1536)
    LIMIT ?
)

Steps To Reproduce

Steps to Reproduce

1. Use PostgreSQL with the pgvector extension installed.
2. Run a query that uses ?::vector. Example:

use Illuminate\Support\Facades\Route;
use Illuminate\Support\Facades\DB;

Route::get('/test', function () {
    DB::select('
        SELECT ARRAY[0.0, 0.1, 0.2, 0.3, 0.4, 0.0]::vector(6) AS test_vector
    ');
});

4. Open the query in Telescope.

[github-actions]

Thank you for reporting this issue!

As Laravel is an open source project, we rely on the community to help us diagnose and fix issues as it is not possible to research and fix every issue reported to us via GitHub.

If possible, please make a pull request fixing the issue you have described, along with corresponding tests. All pull requests are promptly reviewed by the Laravel team.

Thank you!

[vigneshgurusamy]

I too have similar issue when the query has type cast Eg: created_at::DATE.

The telescope uses sql-formatter package format() method which requires language input to render the SQL correctly.

Ref: https://github.com/sql-formatter-org/sql-formatter/blob/9c3feb4bf0bff0cd6ceaa9a487f1aa521e79f7a4/docs/language.md

telescope/resources/js/screens/queries/preview.vue

Lines 15 to 17 in 9c19a24

	formatSql(sql) {
	return format(sql);
	}

Solution

If we could use the query connection name to derive the language input value, then it should solve this issue.

Default Language

With postgres as language