Package org.pjdbc.sql

Class SchemaTransformer

java.lang.Object
org.pjdbc.sql.AbstractJdbcTransformer
org.pjdbc.sql.SchemaTransformer
All Implemented Interfaces:
JdbcTransformer
public class SchemaTransformer extends AbstractJdbcTransformer
Transformer that adds a schema prefix to table names in SQL.

Prefixes unqualified table names after FROM, JOIN, INTO, UPDATE, and TABLE keywords. Already-qualified names (containing a dot) are not modified.

URL Configuration

 jdbc:filter[schema=tenant_123]:jdbc:postgresql://localhost/db

Examples

  • SELECT * FROM users → SELECT * FROM tenant_123.users
  • SELECT * FROM public.users → unchanged (already qualified)
  • INSERT INTO orders → INSERT INTO tenant_123.orders
  • UPDATE customers SET → UPDATE tenant_123.customers SET

Limitations

  • Uses regex heuristics - may not handle all SQL dialects perfectly
  • Does not parse SQL AST
  • May prefix non-table identifiers if they follow table keywords
See Also:
  • invalid reference 
    FilterDriver