2 ms·

To be honest, I'd rather the security of the query wasn't handled by your thing. My data source shouldn't allower user bob to ever be able to see data that is

To be honest, I'd rather the security of the query wasn't handled by your thing. My data source shouldn't allower user bob to ever be able to see data that is not intended for him. Time to train wouldn't be the problem, it would be a case of letting you guys near the data. The lawyers would have kittens. Having a nice tuning tools would be a good idea, as it allows us to do it. Would the thing nock out an AST, or would it be SQL only? As it stands, one of the benefits of our own DSL (using Irony) is that we can implement the AST in T-SQL or just C# code against POCOs.

thom 14y ago
Well, internally we're just passing around bits of lisp before building the query. Part of the aim in gathering data through our survey is to get a feel for what data sources people want, so it's likely we'll have more than just SQL. Given that, I don't see why we could just have a homebrew, abstract structure as well, if not the internal representation. Also, in my distant C# days I was very impressed with Irony, glad it's still around.