FEAT: Follow Supabase Security Advisor to Use set_path in Functions

[toopay]

Description

This PR implements changes to follow the Supabase security advisory regarding the usage of set_path within database functions. Supabase recommends setting the search path explicitly within functions to prevent unintended security issues that may arise from the default search path configuration.

Type of change

Please delete options that are not relevant.

• [ ] New feature (non-breaking change which adds functionality)
• [ ] Unit Tests

Checklist

• [ ] My code follows the style guidelines of this project
• [ ] I have performed a self-review of my own code
• [ ] I have commented my code, particularly in hard-to-understand areas
• [ ] I have made corresponding changes to the documentation
• [ ] My changes generate no new warnings
• [ ] I have added tests that prove my fix is effective or that my feature works
• [ ] New and existing unit tests pass locally with my changes
• [ ] Any dependent changes have been merged and published in downstream modules

Screenshots (if applicable)

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Flag	Coverage Δ
-race	71.89% <100.00%> (+0.02%)	:arrow_up:
-tags "sonic avx"	71.90% <100.00%> (+0.05%)	:arrow_up:
-tags go_json	71.82% <100.00%> (+<0.01%)	:arrow_up:
-tags nomsgpack	71.84% <100.00%> (-0.02%)	:arrow_down:
go-1.21	71.17% <100.00%> (-0.01%)	:arrow_down:
go-1.22	71.92% <100.00%> (+0.10%)	:arrow_up:
macos-latest	71.91% <100.00%> (+0.09%)	:arrow_up:
ubuntu-latest	71.90% <100.00%> (-0.02%)	:arrow_down:

Flags with carried forward coverage won't be shown. Click here to find out more.

Files with missing lines	Coverage Δ
pkg/resource/import.go	78.94% <100.00%> (ø)
pkg/state/state.go	79.82% <100.00%> (+0.17%)	:arrow_up:

... and 1 file with indirect coverage changes