[BUG] Functions with knowable dependencies are created before the tables they depend on

Start in function_sql_vertex_generator.go around lines 81-100, then compare the function dependency handling with GetViews and the View.TableDependencies field. Trace GetDependsOnFunctions and GetAddAlterDependencies to determine how table dependencies can be represented and used. Reproduce the issue with the provided schema.sql and verify that the generated plan creates JobRun before jobRunClaimNext.

Describe the bug

When pg-schema-diff generates a plan, functions defined with RETURNS SETOF "MyTable" are scheduled before the referenced table.
The dependency exists in PostgreSQL's pg_depend, so the information is available.

Expected behavior

pg-schema-diff should detect table dependencies referenced by functions and ensure that the functions are created after their dependencies.

To Reproduce

1. Add the schema below to a migration file.
2. Run pg-schema-diff (plan/apply) against an empty database.
3. Observe ERROR: relation "JobRun" does not exist because the function runs before the table is created.

-- File: schema.sql
CREATE TABLE "JobRun" (
  "runId"  BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  "type"   TEXT NOT NULL,
  "status" TEXT NOT NULL
);

CREATE OR REPLACE FUNCTION "jobRunClaimNext"(p_types TEXT[])
RETURNS SETOF "JobRun"
LANGUAGE sql
AS $$
  SELECT r.*
  FROM "JobRun" AS r
  WHERE r."status" = 'PENDING'
    AND r."type" = ANY (p_types)
  LIMIT 1;
$$;

Context

pg-schema-diff version: v1.0.2
pg-schema-diff usage: CLI
Postgres version: 17
pg_dump of database: N/A

Possible solution plan

I've never touched a line of Go code, so I passed the above info to Claude, and here's a summary of what it says:

• function_sql_vertex_generator.go: Lines 81-100: GetAddAlterDependencies only tracks function-to-function dependencies via DependsOnFunctions
• No mechanism to track table references in function bodies
• Query pg_depend to find actual table dependencies (similar to GetViews)
• Add a TableDependencies field to schema.Function (like View.TableDependencies)
• Extend GetDependsOnFunctions query or create a new GetDependsOnTables query
• Use these dependencies in GetAddAlterDependencies

Alternatively, if there were a way to impose order from the command line or via the naming of the .sql schemas, that would work too.