Retrieve Current User using SQL query

This query retrieves the current user's name by matching the user ID from the system$session_user table with the id in the system$user table. It identifies the logged-in user based on their session data and fetches their name accordingly.

SELECT "name"
FROM "PUBLIC"."system$user"
WHERE "id" = (
    SELECT "system$userid"
    FROM PUBLIC.PUBLIC."system$session_user"
    LIMIT 1
);