Is there any way to access values across multiple, chained connections in Knack as you would in a SQL query?
Example: Suppose I have Objects: A, B, C.
Object A contains a Number: A_Value.
Object B contains an Equation: B_Equation. And B has M:1 connection with A (B connects with one A, A connects with many Bs).
Object C contains an Equation: C_Equation. And C has 1:1 connection with B.
Currently, B_Equation can access A_Value through the connection, but C_Equation cannot access A_Value. Now, I haven't written SQL queries recently, but I'm pretty sure that a SQL query could chain from C to B to A.
Of course, I could include a direct connection from C to A, but this seems like storing redundant data and could be confusing for end-users.