Surya Asriadie

> where.Not(rel.FilterField("bool_column")) I think specifying `rel.FilterField` in every field will make the api too verbose and not compact. > while this is possible also with rel.FilterFragment provided column name will...

I did something similar in the previous reincarnation of this library, and the code get messy easily https://github.com/Fs02/grimoire/blob/af0b7afd317048419836fafc91f0caf3323b9f8e/query_test.go#L74-L77 I can't always control and suggest how other use the API, so...

Thanks, glad to have some help as well 😄

@bickyeric do you have any thought with the current design? The current design might look similar with activerecord [has many through](https://guides.rubyonrails.org/association_basics.html#the-has-many-through-association) and [has_one_through](https://guides.rubyonrails.org/association_basics.html#the-has-one-through-association), but it's not since it's not required...

@bickyeric after looking back to the design, you are right, the problem is we cannot infer which field inside the immediate table we should use to point to the next...

sounds good to me

> Should SQLite just return error as it does not support alter column? agree

> How to detect that type have changed? How to detect what constraints need to be changed? I haven't look at postgres, but after looking at mysql doc, how about...

> This could probably work but still question is how to pass on to what constraint exactly needs to be changed? Create bitwise enum? oh, do you mean to pass...

> For MySQL to change not null it would still require to use AlterColumType would it need to panic if not used otherwise or just do not generate SQL as...